Report Totals Disappear...

[tanyalee123]

I have a report that is run from a query. The purpose of the report is to see totals, so in my report I am using this type of syntax to get totals: =DCount("*","[qryAdvocacyPhone_Totals]","[BENEFITS_Advocacy]") for each field that I want totals on. Works great!!

However, the report is useless without a date range, so I entered date criteria in the query as so: Between ["Enter beginning date"] and ["Enter end date"]. When I run the query, it works fine; I get the results within the date criteria. But when I run the report now with the date criteria in it, my totals don't show up at all; they are blank. I am at a loss as to why this would be.



Anyone have an idea? Let me know if you need anymore info. Thanks!!
Tanya

[June7]

Domain aggregate functions pull data directly from table - not the report's recordset. It should aggregate data for all records, regardless of date range criteria because that criteria is not in the DCount filter argument. Don't know why not showing.

If you want a count of the report's records, use Count(*) in textbox in report header/footer section.