Very Easy, but cant find the 'FOR DUMMIES' thread

[Steven.Allman]

I love access reports and forms, but never messed with Query's.
I have lots of data in a few tables, but need to create my query to group all of CAT1 and give me total SALES, then all of CAT2 to give me total SALES, and CAT3, etc...

I know that is the basis for each of these threads is for this, but you all are asking more advanced info....

[SteveI]

Open a new query in Sql view and type

SELECT SUM(column_name)
FROM table_name

You need the parentheses (brackets) in when you type the column name.

Then click the RUN button. (big Exclamation mark)

This will add up everything in the column specified.

I know you have more than one table to try but I'm afraid this is the SUM of my knowledge on queries - at least it's a start for you.