<div>
Thanks. Your solution worked perfectly.. Also thanks for replying back so quickly
</div>


Thanks. Your solution worked perfectly.. Also thanks for replying back so quickly

<div>
You are welcome ...<br />
Thank you for using Experts Exchange ...<br />
<br />
mx
</div>


You are welcome ...
Thank you for using Experts Exchange ...

mx

<div>
<div class="content wysiwyg-content">
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 <a href="https://filedb.experts-exchange.com/incoming/2011/02_w07/408925/screenshot.jpg" target="_blank" title="screenshot of query (145 KB)"><img alt="screenshot of query" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2011/02_w07/800_408925/screenshot.jpg" /></a>
</div>
</div>


screenshot.jpg

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 

How do use group by in ms access 2003

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.