Adding stats....

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there any way to use a report to add up different phrases? I use Access to
keep track of our repairs. I would like to make a monthly report that would
would tell me by technician how parts are good, bad or awaiting parts, and
what was done to repair a part.

I would like something like this:
Good Bad Awaiting Parts No Problem Replaced abc part
John doe 10 5 7 7
8
John Depp 12 8 2 3
9

In the database good, bad, awaiting parts is stored in the condiction field.
So i need a way to add up how many times good or bad is in that column for a
certain technician.

I hope this explaination is clear....please help.

Thanks
Gary
 
Have you tried creating a Crosstab query? The technician is the Row Heading
and Condition is the Column Heading. Count(Technician) is the Value. You may
need to enter all possible Conditions into the Column Headings property.
 
Thank you very much! Thats works great. I have only one more question. How do
you limit the query to a certain month or time frame?

Thanks!
Gary
 
You limit a crosstab query using the same method you limit any query except
you must enter the data types of all parameters. Select Query->Parameters
and enter your criteria parameters and types.
 
Back
Top