I have a query with a parameter prompting for a date range,
(Between [Enter 1st date] and [Enter last date]). In the report which pulls data from this query, I need 2 total fields which pull the totals of an assessment amount for each type of account.
CourtCosts: totalassessment
(=DSum("[ADJASSD]","qrytest2","[ACCTNO]=20000000"))
Fines: Totalassessment
(=DSum("[ADJASSD]","qrytest2","[ACCTNO]=30000000"))
I'm getting errors in these fields, but if I use a particular date range in the query, "between 08/01/2006 and 08/31/2006", then I get the correct data in the reports total fields.
Any suggestions???
(Between [Enter 1st date] and [Enter last date]). In the report which pulls data from this query, I need 2 total fields which pull the totals of an assessment amount for each type of account.
CourtCosts: totalassessment
(=DSum("[ADJASSD]","qrytest2","[ACCTNO]=20000000"))
Fines: Totalassessment
(=DSum("[ADJASSD]","qrytest2","[ACCTNO]=30000000"))
I'm getting errors in these fields, but if I use a particular date range in the query, "between 08/01/2006 and 08/31/2006", then I get the correct data in the reports total fields.
Any suggestions???