Making a Grid from 3 data fields in Access -
08-13-2004
, 11:53 AM
I am trying to find some way of displaying data in a "grid-like" style
in MS-Access 2000 with data from a query.
The query table separates my data like this:
Time of day - Day of the week - Number of hits
08:00 - Monday - 45
09:00 - Monday - 15
..
..
..
08:00 - Tuesday - 23
..
..
..
10:00 - Saturday - 12
..
etc.
the data is grouped by Day of the Week.
Basically what I want is to have a grid display where the "times of
day" will be on the left (the X axis) and the "days of the week" on
the right (the Y axis) and the relevant "number of hits" in its
appropriate postion in the grid.
Kind of like:
Mon Tue
08:00 45 15 . . . .
09:00 23
..
..
..
I have no idea on how to go about doing this, preferably, I'd like
this in Report form but if an Access Form is the only way to get it
done than that's fine as well.
Thank in advance for any possible help.
Patricia McConnell |