Report Subtotal

[tlnini]

Sorry if this is a entry level question. I am generating a report based on a query, and I was wondering if I can generate a subtotal for the report based on the results return from the query.

Thanks

 

[GoDawgs]

Create a Footer for the grouping that you want to subtotal...then put in a text box in the footer that says something like:

=sum([thefieldtosum])

Say you want to create totals by state...you would click on the grouping button, select the field that you want to group (state in this case) and then select "yes" for footer.

Hope that helps.

Kevin

 

[tlnini]

Thanks! It helped!