This would be better done in a report.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/...UBED1=ACCESS-L

"Siegfried Heintze" wrote in message
...
I have a bunch of restaurant receipts in a database and I want to sum all
the items of each receipt. Each row of the result set would be a receipt
number and a sum of the price of the line items.

What might a query like this look like?

Is is possible to write a query that would list all the line items grouped
by receipt numbers with sub totals for each receipt?

Thanks,
Siegfried