My data looks like:
Model: SerialNu. Failure: Problem: Correction:
T50 343X4 34 Cooler Repair
T55 85B10 34 Downline Replace
T50 345F2 34 Cooler Repair
T50 322A6 19 Pump Replace
T55 84A45 34 Cooler Repair
My query for Failure comes out like this:
34 Cooler Repair
34 Cooler Repair
34 Cooler Repair
34 Downline Replace
Which is okay, the techs can see that the cooler causes failure 34 more that
the Downline.
I would like the query to COUNT the records:
34 Cooler Repair 3
34 Downline Replace 1
Any ideas?
Email okay.
Thanks
Alan