How to get a total sum in a qurey to be on a report?

[smc678]

I have a query that is a total sum. I need that number to be on a report...

[June7]

Options:

1. use Sum function in textbox in report or group header/footer section to summarize records of the Detail section

2. domain aggregate function (DSum, DLookup, etc)

3. include in the report RecordSource

4. subreport

[smc678]

error? =DSum([SumOfTotal],[qryaQFFTotalRgis]![SumOfTotal])

[June7]

Enclose each argument in quote marks.

=DSum("fieldname with data to sum","table or query name","filter criteria here if needed")

[smc678]

Fixed!!!!!! Thank you thank you