M Milan Registered User. Local time Today, 16:18 Joined Feb 17, 2002 Messages 85 Aug 9, 2002 #1 why is this not working!!! Me!ACTUALSD7 = DSum("[Actualscore]", "TblComplianceLine", _ "[Process] = 'SD' AND [AuditDate] = '"&xdt&",'") Would be grateful for the solution!!! milan
why is this not working!!! Me!ACTUALSD7 = DSum("[Actualscore]", "TblComplianceLine", _ "[Process] = 'SD' AND [AuditDate] = '"&xdt&",'") Would be grateful for the solution!!! milan
Travis Registered User. Local time Today, 08:18 Joined Dec 17, 1999 Messages 1,332 Aug 9, 2002 #2 is this a Date or a text field ...[AuditDate] = '"&xdt&" If its a Date Use th # instead of '.
pdx_man Just trying to help Local time Today, 08:18 Joined Jan 23, 2001 Messages 1,346 Aug 9, 2002 #3 Me!ACTUALSD7 = DSum("[Actualscore]", "TblComplianceLine", _ "[Process] = 'SD' AND [AuditDate] = #" & xdt & "#") assuming xdt is a valid date datatype HTH
Me!ACTUALSD7 = DSum("[Actualscore]", "TblComplianceLine", _ "[Process] = 'SD' AND [AuditDate] = #" & xdt & "#") assuming xdt is a valid date datatype HTH
