I inherited a database that had tables structured so they were like spreadsheets instead of being normalized. I've fixed that with a new table design, but would like to design a query so that it looks like it did previously. What we are doing is going to several Areas and recording the Time and a Count of people. Before, the database had Area1, Time1, Count1, Area2, Time2, Count2, etc. Here, is a second table for the Area, Time, Count.
Here are the table relationships and a crosstab query that I tried. The Crosstab cannot incorporate times and I'm not sure how to proceed. Other types of joins didn't work for me.
which looks like
I would like it to look like this:
I could probably do this in R, but my users don't use R so I want them to be able to view it in Access.
Thanks for any help you can provide. Hopefully I can keep up with the code!