sum up qty's of like products

In access 2007, I need to create an easy query to add up the following data.

SKU                  Description          QTY
FZ0567600         Skateboard           50
FZ0567600         Skateboard           40
FZ0567600         Skateboard           30

Can you help me create a query from the following that will combine/ total the qty's together for like SKUs?  I can't figure it out.  This would help me so much.  Thank you in advance!!
Who is Participating?
Rey Obrero (Capricorn1)Connect With a Mentor Commented:
if you look at what i posted, i use SUM in the Qty field NOT the SKU field
LamrskiAuthor Commented:
That was funny...I said an easy query...if it were easy, I wouldn't be asking...wrong wording there!  :)
Rey Obrero (Capricorn1)Commented:
select sku, sum([qty])
from tableName
group by SKU
Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

LamrskiAuthor Commented:
I need more help...more specifics? I hope this screen shot will help.  Thank you capricorn!
Create query, select table.
Drag fields to grid.
Click Total button on ribbon.
Under Qty column change Group By to Sum

You end up with what  capricorn1 suggested.
LamrskiAuthor Commented:
Thank you...Sorry for the late feedback.
I have since been able to use this new tool quite a bit!!
Thanks again!!
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.