DCount Syntax Help

systematic

Registered User.
Local time
Today, 15:36
Joined
Sep 13, 2005
Messages
28
Hi all,

I have scoured the net and these forums....although there is plenty of information on DCount I can't seem to find the answer to my question so thought it was time for a post.

I am trying to get the following to work -

PSOutstanding = DCount("*", "tblEnquiries", "[Owner] = strPS")

or alternatively, reference the control directly (instead of strPS, use Me.cboConsultant)

I have tried that many different combinations of " and ' still with no joy - the best I can do is return a value of zero.

Could someone please help me out with the syntax? btw...strPS is a text string - in case this is relevant.

Thanks

Robert :(
 
Always the way....as soon as I post I figure it out :)

PSOutstanding = DCount("*", "tblEnquiries", "[Owner] = '" & strPS & "'")
 

Users who are viewing this thread

Back
Top Bottom