count duplicate items

[MariaZ]

Please, help!

This is my report (Detail section):

Product Man Type (tree text-boxes)

monitor LG 17" LCD
monitor LG 17" LCD
printer HP laser

How to get this:

monitor LG 17" LCD qty: 2
printer HP laser qty: 1

I know how to hide duplicates, but how to calculate quantities

Thank you...

 

[John Big Booty]

Welcome to the forum.

Check out the Totals option in your query. You would Group By your product and also Count them.

 

[MariaZ]

It works!
Thank you!