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]", "tblDownloa d", "[Buyer ID] = "" & me.txtBuyerIDTo p &
"" ")

Any idea's?

--

Thank You,

Nick Jones
Customer Services
Blue Lagoon Products

[deluxeinformation@gmail.com]

Re: DCount


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]", "tblDownloa d", "[Buyer ID] = "" & me.txtBuyerIDTo p &
"" ")
>
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]", "tblDownloa d", "[Buyer ID] = " & me.txtBuyerIDTo p)


Bruce