Syntax problem with DCOUNT and string variable

atrium

Registered User.
Local time
Today, 22:16
Joined
May 13, 2014
Messages
348
= "(" & DCount("*","ItemsOrderedOnlyQry","[OderNo] = '"OrderNoFld"'") & ")"

The error I get = "The expression you entered contains invalid syntax
You may have entered an operand without an operator

I have been staring at this and looking for examples but I just can't work it out. When it's pointed out
OrderNoFld = string


I would appreciate any help
 
DCount("*","ItemsOrderedOnlyQry","[OderNo] = '" & OrderNoFld & "'")
 
Thanks Arnelgp.
I changed mine to be exactly like yours and it still didn't work.
I copied yours and pasted it into the code and worked.???
Thanks again mate
 

Users who are viewing this thread

Back
Top Bottom