[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 613
  • Last Modified:

How do use group by in ms access 2003

I'm looking to group by item id, but instead my query is listing every transaction from 2010. I want the query to sum all qty's sold for each item in 2010 screenshot of query
0
solarisinfosys
Asked:
solarisinfosys
  • 2
1 Solution
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Try this:

Under the Time column, change Group By to WHERE and uncheck the box

mx
0
 
solarisinfosysAuthor Commented:
Thanks. Your solution worked perfectly.. Also thanks for replying back so quickly
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
You are welcome ...
Thank you for using Experts Exchange ...

mx
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now