I have a report that groups invoices by invoice number. THe details show the items on the invoice with amounts and total them up. I run the report selecting by date the invoices are raised. It work really well.

 

I need to select invoices over a particular time period that show a particular item, some will have > 1 item but I need to show all items on the invoice if the one item appears on it.

 

What is the best way to do this?

 

Hoping someone can help

 

Troubled....

Thats great. I got as far as the sum  but then got a bit stuck.

 

Will give it a go.

 

Many thanks