using DSUM and struggling

[Richhol65]

Hi

Hopefully someone can help.

I am trying to use dsum to calculate a sum from either a table or query to display on a form and this needs to be for different services within a period so I am using the following:

Me.txtTotalEarnings = DSum("Price", "KatiesPeriodTakings", "AppDate" >= CDate([Forms]! _& 
[frmKatiesTakings]![txtStartDate]) And "AppDate" _& 
 <= CDate([Forms]![frmKatiesTakings]![txtEndDate]))

But I keep getting a mismatch error

The Query is called KatiesPeriodTakings
The field I want totalled is called Price
The date field is AppDate and the 2 controlling dates are the Startdate and EndDate from the Form

Thanks

Rich

 

[pbaldy]

Note the date delimiter:

http://access.mvps.org/access/general/gen0018.htm

 

[Richhol65]

Thanks PBaldy

I have now changed the code to this:

Me.txtTotalEarnings = DSum("Price", "KatiesPeriodTakings", _ &
 "AppDate" >= CDate([Forms]![frmKatiesTakings]![txtStartDate]) And _ &
"AppDate" <= CDate([Forms]![frmKatiesTakings]![txtEndDate]))

But I am still getting a type mismatch

Thanks

Rich

 

[pbaldy]

Have you tried the syntax and # delimiter from the link?

 

[Richhol65]

Paul

Thanks for that it is now working perfectly

Cheers

Rich

 

[pbaldy]

Happy to help Rich.