It's here! We're in the last week of research! Well, at least I am. In honor of that:
Okay, but really today I just worked on the VBA more (surprise, surprise). For those of you really interested, one of the problems I was running into was that I was using the Count feature in SQL, but that doesn't record instances where the count is zero. These are still significant in our data, so I was spending today looking into various work-arounds to this problem. The first way I had thought of involved using the complete columns that had no zero values, and comparing those to the incomplete columns once it was in Excel and then using that to add in cells with zero values in the appropriate places. Basically, this is just automating what I did manually, but manually it is very intuitive and to automate it is much more difficult conceptually. The other avenue I checked out was possibly changing the SQL to somehow account for the zero values. I read around that it might be possible to use the NULL values and have them counted as zeros if I did a left self join on the table, but Access is being incredibly difficult with joins and will accept just about none of my queries.
Update: I got the join syntax right and it ran the query! However, it did not, as promised by the internet, count any of the zeros so I'm really still back to square one. Sigh.
Update: I got the join syntax right and it ran the query! However, it did not, as promised by the internet, count any of the zeros so I'm really still back to square one. Sigh.