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
Who is Participating?

Improve company productivity with a Business Account.Sign Up

DatabaseMX (Joe Anderson - Microsoft Access MVP)Connect With a Mentor Database ArchitectCommented:
Try this:

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

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

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.