Producing reports with sums from a subform 1

[osp001]

I'm having problems producing a report that has all the information I want. Specifically, I'm producing a purchase request form, and it has a number of items, along with catalog numbers, quantities, prices, etc. I use a subform to enter these data.

From this subform, I use a query to generate totals for each line (quantity * unit_price). However, I have been unable to figure out how to produce a subtotal for the report. This is to say, I have the "sigma" function in queries down, but can't get it to work with the current query. I've tried to put it together in the report, but can't get it to work.

So- I need to sum the line totals, and can't figure out how to do it without a separate query- now I can't figure out how to get the result from that second query in the report.

Is there an easier way to do this? Thanks!

 

[nkiefer]

I total everthing in the footer of the subreport and then reference that form the main form. Goto

http://support.microsoft.com/?kbid=208998

for additional info.