Grouping showing multiple identical values

  • Thread starter Thread starter rgrantz
  • Start date Start date
R

rgrantz

I have:

ProdTable with Order Number (Order Number is unique)
ItemTable with item ID per order (there can be many items per order, or just
one - Item ID is unique)
QCTable with defects and count of each per item (there can be multiples of
one defect per item, or several defects on one item, etc.)

I have some good detailed reports outlining errors per item, but I'm trying
to make a report that shows a total of each error type

For instance:

Order Number Item ID Defect Qty of Defect
123 Item 01 crack in case 4
123 Item 01 Discoloration 2
123 Item 02 crack in case 2

234 Item 23 Discoloration 1
234 Item 24 crack in case 1

The report I want would show:

Crack in Case - 7
Discoloration - 3

It's just a total of each error type instance, regardless of Item or order.

It seems like it would be simple, but for some reason the report I've made
with the group level of Defect Type is repeating the Defect Type values
instead of totalling all instances of each.

Is there soemthing I need to do w/ summing queries before using a report?

Thanks for any help, the aid I've received via these newsgroups has been of
a very high caliber
 
In the Query Builder, bring down to the grid from your Tables the
information you want... defect type and count... then on the Menu, View |
Totals... Group By defect type, and Sum count.

Larry Linson
Microsoft Access MVP
 
Thanks, Larry, I could have sworn that that's what I had one of these times,
but that did the trick. I might also have forgotten to make the Date
criteria a "Where" from the Group drop-down properties in the query grid,
because I see from an old copy of the query that it's set wrong.

Thanks again
 
Back
Top