access report summary

[mattsuppok]

How do I place a field on a report that will place a grand total for ALL the records in one field on the query? I have several grouping levels already and I open the report with parameters in my query criteria. Thank you for any help...

 

[PaulBricker]

You put the textbox that will hold the information in the Report Footer. Then do the Sum([FieldName]) There

Paul

 

[mattsuppok]

That will not give me a grand total for that field from that query. At least not when placed in the form footer section. All it does is sum up the subtotals on the report. As I stated I am using parameters to limit the data on the report. But in the grand total section I wish to total all data from the query. Try again????

 

[PaulBricker]

Create a Totals query that sums all the values you want and then use DLookUp to populate the textbox in your Report. The syntax is something like this:

=DLookUp("SummedField","TotalsQueryName&quot

Paul