DSum not working when Date Criteria Added

[pnpez]

Hello,

I have the following DSum that works fine until I add a Paid Date criteria. The field Paid Date is formatted "Date/Time" in the table.

AE CTAS By DateT: IIf([GeneralManager]="No RVP" Or [GeneralManager]="",0,DSum("[Service Commission].[NetSale]","Service Commission","[ID] <= " & [Service Commission].[ID] & " and [Service Commission].[Paid Date] = " & [Service Commission].[Paid Date]))

Can anyone tell me what I'm doing wrong?

Thanks

 

[pbaldy]

This should help:

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

 

[pnpez]

Sorry, but the link pointed me to DLookup formulas. That's not what I'm trying to do.
I also searched within the site but couldn't find a common issue.
Thanks

 

[pbaldy]

And the link says "Note that the same logic applies to most Domain Aggregate Functions (DMax, DMin etc.)". The relevant point is that date values need to be surrounded by the # delimiter.

 

[pnpez]

Sorry, I got it now. I'll give it a try.
Thanks for your help.
Paul

 

[pbaldy]

No problem; post back if you get stuck.