I need to build a table in access based off of data from a query
The query has columns Called Arrival Hour, Arrival Date, Finish Hour, and Finish Date
I need to build a table that shows the last 21 days in the Left Hand Column (Dynamic)
Then have a column for each hour (0, 1, 2, 3, 4...23) with a "Count If" Type formula to populate each one....
is this something that is Impossible..........Possible.........Probable?
The formula would count if:
Arrival Date is Less than or equal to the Rows Date
Arrival Time is Less than the Time of the header in the column to the right
Finish Date is Greater than or equal to the Rows Date
Finish Time is Greater than or equal to the the Time of the header in the column to the right
-I know this is asking for a lot..........i can break the question up into multiple questions for more points if required........but i've hit a wall.......I can do this in excel no problem..........but it turns out that the requirement is in access.......fml