dCount query

[Blue Lagoon Products - Customer Services]

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 in**@bluelagoonproducts.com quoting your eBay
item number, eBay ID, Postcode and order number.

[Bob Quintal]

"Blue Lagoon Products - Customer Services"
<in**@bluelagoonproducts.comwrote in
news:ES******************@fe1.news.blueyonder.co.u k:

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 ?

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.