DCount

[Blue Lagoon Products - Customer Services]

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

[deluxeinformation]

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