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....