How to use subtotals in queries

[viral_patel1981]

I have a simple query with several tables.

e.g. rep sales
1 500.00
1 600.00
1 500.00
1 600.00
2 500.00
2 600.00
2 500.00
2 600.00

what i want to do is have this totaled up to look like something below

rep sales
1 500.00
1 600.00
1 500.00
1 600.00
subtotal rep 1: 2200
2 500.00
2 500.00
2 500.00
2 500.00
subtotal rep 2: 2000

can this been done in query design mode. i'm a real basic user, sorry.

 

[KenHigg]

Will you be printing this data?

Ken

 

[viral_patel1981]

yes eventually

 

[Ukraine82]

If you're going to print it I suggest you make a report from that subtotal query. Be sure to make a sale rep footer.

If you wish to print it from a query then you will need to make an additional total (sum)query just to break down the sale rep.

Sorry Ken for jumping in I figured I might help you out.

hth,
Michael

 

[KenHigg]

Sorry Ken for jumping in I figured I might help you out.

hth,
Michael

It's all good - Glad we were on the same page

Ken

 

[viral_patel1981]

so a total(sum)query will allow me to insert subtotals into my existing query?

 

[KenHigg]

The point I was going to make was to let the total stuff happen in the report.

Ken

 

[viral_patel1981]

i thought as much. thats fine thank you for your help guys. much appreciated