Hi,

Here is my expression

=DCount("[Buyer ID]","tblDownload")>2

I would like to know how many records (including this one?) contain the same
'Buyer ID' as that in txtBuyerID on my report, is this correct ?

--

Thank You,

Nick Jones
Customer Services
Blue Lagoon Products

Please send all e-mails to info (AT) bluelagoonproducts (DOT) com quoting your eBay
item number, eBay ID, Postcode and order number.

"Blue Lagoon Products - Customer Services"
<info (AT) bluelagoonproducts (DOT) com> wrote in
news:ESYMg.20197$89.14547 (AT) fe1 (DOT) news.blueyonder.co.uk:

No, this will tell you that the count of all buyer IDs in the
table, including duplicates are greater than 2.

What you need is
=DCount("[Buyer ID]","tblDownload",
"[Buyer id] = " & me.txtBuyerID & ")"
if [Buyer ID] is a number.
Or
=DCount("[Buyer ID]","tblDownload",
"[Buyer id] = """ & me.txtBuyerID & """)"
if it's in a text field in the table.
--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com
Warning: Do not use Ultimate-Anonymity
They are worthless spammers that are running a scam.