dbTalk Databases Forums  

Making a Grid from 3 data fields in Access

comp.database.ms-access comp.database.ms-access


Discuss Making a Grid from 3 data fields in Access in the comp.database.ms-access forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Patricia McConnel
 
Posts: n/a

Default 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

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.