If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Pivot Table Access 2000?
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 |
#2
|
|||
|
|||
Never Mind - The answer was staring me in the face the whole time - Crosstab
Query!!! Aaron |
#3
|
|||
|
|||
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 "Air-ron" wrote in message news Never Mind - The answer was staring me in the face the whole time - Crosstab Query!!! Aaron |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Access 2000 DB in Access 2002 | Tony_VBACoder | General Discussion | 2 | July 28th, 2004 01:23 AM |
Problem running Access 2003 and Access 2000 apps on same machine. | Rathtap | General Discussion | 3 | June 13th, 2004 01:30 AM |
How to extract data from multiple Access databases to create a Pivot table | Android | Worksheet Functions | 4 | February 6th, 2004 03:22 PM |