Totals in Access

  • Thread starter Thread starter Lisa
  • Start date Start date
L

Lisa

I have a furniture database I need some help with. I have a query that I have
run by Sheet Number, then sorted by Room number. I need to be able to run a
query that will show the total of each furniture item on the sheet. For
example, how many patient chairs, guest chairs, bed tables, etc. I am a
beginner with Access so the simplest method would be appreciated. Thank you!
 
In the query design wizard, there is a little E button at the top in your
tools. That changes your query fields to a gruop. On the ones you want sums
on, change the group by to sum.
 
Back
Top