Grouping Records

  • Thread starter Thread starter DS
  • Start date Start date
D

DS

I have a query that shows Invoice Numbers with each Item sold that is
attached to that invoice number. Its reading this way.

1776 Item1 $10.00
1776 Item2 $15.00

I want it to read like this....

1776 $25.00

How can I do this?

Thanks DS
 
First, remove the Item field from your query. Click on the Sigma (looks like
E) button on the toolbar at the top of the screen. Go down to your Amount
field and change Group By to Sum. Run your query and you will now get what
you want.
 
PC said:
First, remove the Item field from your query. Click on the Sigma (looks like
E) button on the toolbar at the top of the screen. Go down to your Amount
field and change Group By to Sum. Run your query and you will now get what
you want.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com
Click to expand...
Wow!!!! That was quick and Easy!
Thanks
DS
 
Back
Top