I know this is basic but ive read the books and i just cant get my head around this... please help, if i get it once ill crack it after that....

I have a form with 20+ subforms. So a MAIN table and 20+ SUB tables...

Each record in the SUB table has 3 fields to add together to get a subtotal... the subtotal is then applied to a catagory based on the selector of another field in the record....

So F1+F2+F3=SUBTOTAL
SUM SUBTOTALS WHERE F4=A
SUM SUBTOTALS WHERE F4=C
ETC.....

Then i need to SUM all the TABLES still in catagory A,B,C etc...
Then SUM the catagories...

Should i do this as 1 query or use a query for each table and add the queries?
How do I set up the table query...??????

Cheers in advance......