Solved

How do use group by in ms access 2003

Posted on 2011-02-12
3
604 Views
Last Modified: 2012-05-11
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
Comment
Question by:solarisinfosys
  • 2
3 Comments
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Access MVP) earned 500 total points
ID: 34881312
Try this:

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

mx
0
 

Author Closing Comment

by:solarisinfosys
ID: 34881441
Thanks. Your solution worked perfectly.. Also thanks for replying back so quickly
0
 
LVL 75
ID: 34881474
You are welcome ...
Thank you for using Experts Exchange ...

mx
0

Featured Post

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question