S
SNFGC
On a report I am using the following calculated field to give me a total count for each ACCOUNTING-CODE (1-7).
=DCount("[ACCOUNTING-CODE]","Total-exception-report-General Cash","[ACCOUNTING-CODE] = '1' ")
I get the correct results, but when I put the following expressions Between [Beginning Date] And [Ending Date], on the date field in my query (Total-exception-report-General Cash ), the calculated fields on my report displays #Error.
Why would adding Between [Beginning Date] And [Ending Date] to the date field to limit the records in the query cause the calculated field on my report to display #Error.
Thanks
Bill
=DCount("[ACCOUNTING-CODE]","Total-exception-report-General Cash","[ACCOUNTING-CODE] = '1' ")
I get the correct results, but when I put the following expressions Between [Beginning Date] And [Ending Date], on the date field in my query (Total-exception-report-General Cash ), the calculated fields on my report displays #Error.
Why would adding Between [Beginning Date] And [Ending Date] to the date field to limit the records in the query cause the calculated field on my report to display #Error.
Thanks
Bill