Item count

[Guest]

In my database as each item is counter into inventory it is added as a new
line. When I do a report it shows all the lines of the same item. How do I
just get a quanity total of the item?

Thanks


Cat

 

[Guest]

My line of thinking is to base the report on a totals query.

When you create a query just click on the sigma symbl (looks like an "E")
and decided what grouping and totals you want.

 

[Guest]

You could use the count formula in your report.