Re: Adding stats....

Tech-Archive recommends: Fix windows errors by optimizing your registry

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.

--
Duane Hookom
MS Access MVP

"Cooptoons" <Cooptoons@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:36052812-6FE3-4703-9C1C-AB21592C81D5@xxxxxxxxxxxxxxxx
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


.