By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,491 Members | 1,868 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,491 IT Pros & Developers. It's quick & easy.

DCount

P: n/a
Hi,

I have this below but it is always returning the value as 0, even when there
is more than 1 record.
=DCount("[Buyer ID]", "tblDownload", "[Buyer ID] = "" & me.txtBuyerIDTop &
"" ")

Any idea's?

--

Thank You,

Nick Jones
Customer Services
Blue Lagoon Products
Sep 12 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a

Blue Lagoon Products - Customer Services wrote:
Hi,

I have this below but it is always returning the value as 0, even when there
is more than 1 record.
=DCount("[Buyer ID]", "tblDownload", "[Buyer ID] = "" & me.txtBuyerIDTop &
"" ")

Any idea's?
If BuyerID is a number and not a character string then you've got too
many double quotes. This should work:

DCount("[Buyer ID]", "tblDownload", "[Buyer ID] = " & me.txtBuyerIDTop)
Bruce

Sep 12 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.