Crosstab Query

  • Thread starter Thread starter geebee
  • Start date Start date
G

geebee

Hi,

I have never dealt with crosstab queries before, but I
was recommended that such a query would be the solution
to my problem.. I have a table which looks like this in
design view:

Field Name: Data Type
ID Autonumber
Year text
pay priod number
uretop number
begin date/time
end date/time
ot hours number
op errors number
facility text

** Note: this table only has the information relating to
one facility, so we eliminate the issue of having more
than one facility.

Here is what I am trying to do:

Create a line graph.
The vertical axis should be the uretop.
The horizontal axis should be the pay period.
There should be two lines in the graph.
One should display the URETOP.
The other should display the OP Errors.

How would I construct the query/datasource to achieve
this?

Thanks in advance,
geebee
 
Back
Top