Summarize

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I have a database that tracks items taken by different user sites. I want
to print a report that lists the items taken for a single site covering a
period of time. The report I currently have lists like this:

Bath Towel 50
Bath Towel 60
Hand Towel 40
Hand Towel 35

Instead of having each item repeat, i would rather it look like:
Bath Towel 110
Hand Towel 75

What am i doing wrong? Thanks for the help!
 
I don't have group in the query. Can you tell me how to make the query with
"where"?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

calculate % change in price for each of 200+ products 1
Pivt or grouping or some other means to summarize data 2
SUMPRODUCT where between 2 dates 3
Epson 2200 Cleaning Pad Replacement 5
Before I get started. . . 5
Form design: Content selection list 0
Group Footer Summarizing Problem 5
Fork 'andles!! 25

Back
Top