DSUM HEEEEELP!!!!Please!!!! (1 Viewer)

[Milan]

why is this not working!!!

Me!ACTUALSD7 = DSum("[Actualscore]", "TblComplianceLine", _
"[Process] = 'SD' AND [AuditDate] = '"&xdt&",'")

Would be grateful for the solution!!!


milan

 

[Travis]

is this a Date or a text field ...[AuditDate] = '"&xdt&"


If its a Date Use th # instead of '.

 

[pdx_man]

Me!ACTUALSD7 = DSum("[Actualscore]", "TblComplianceLine", _
"[Process] = 'SD' AND [AuditDate] = #" & xdt & "#")

assuming xdt is a valid date datatype

HTH