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
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
