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 info@bluelagoon products.com quoting your eBay
item number, eBay ID, Postcode and order number.

[Bob Quintal]

Re: dCount query

"Blue Lagoon Products - Customer Services"
<info@bluelagoo nproducts.comwr ote in
news:ESYMg.2019 7$89.14547@fe1. news.blueyonder .co.uk:

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.