Pivot Table Access 2000?

[Guest]

I created a Database to keep track of Customer Count Data within a Casino. I
may have made a mistake, here, but the main table is a monolith, with the
primary key split between two fields, Date and Time. (we count every 2
hours) The count data is split up into fields for each type of machine in
each zone. For the reports, different zones are combined into two general
areas of the casino, but still split up by machine vendor.

Now, the people farther up the totem pole are requesting that the reports
have this format:

Machine Type Date 12:00AM 2:00AM 4:00AM 6:00AM...


Type 1 10/13/04 Count Count Count Count....
Type 1 10/14/04 Count Count Count Count....
Type 1 10/15/04 Count Count Count Count....
Type 1 10/16/04 Count Count Count Count....

Type 2 10/13/04 Count Count Count Count....
Type 2 10/14/04 Count Count Count Count....
Type 2 10/15/04 Count Count Count Count....
Type 2 10/16/04 Count Count Count Count....

etc...

I can get the look I want using a Pivot Table, but I'm not sure how to
automate the process so my superiors can create, view, print, and email the
reports to their superiors.

I would love to do this without a Pivot Table, to reduce the odds of someone
hitting the wrong button on the screen, as well as to make it easier to print.
Suggestions?
Aaron

 

[Guest]

Never Mind - The answer was staring me in the face the whole time - Crosstab
Query!!!

Aaron

 

[Pieter Wijnen]

isn't it fun how microsoft always find x number of terms for the same thing?
DDE-OLE-ActiveX-?
GPE - bluescreen - not a topic(1) - ?
Pieter