Subtotal in a Query??? 1

[kirstenlargent]

Is there a way to subtotal in a query?

What I'm trying to do is get my data to subtotal and create a separate table with records for only the subtotals on each value, instead of all the detail records in the original table.

Is there any way I can do this?
THANKS!!!

 

[randysmid]

Hi,
Yes, you may want to create two separate queries. The first one will get you the totals. This can be accomplished using the sum symbol on the toolbar. Then, the next query will use the first query as it's source, and this query will become your make table. Make sense? HTH,
Randy Smith
California Teachers Association

 

[kirstenlargent]

Worked EXACTLY like I wanted it to. THANKS!