dCount query - 09-10-2006 , 01:32 PM
Here is my expression
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 ?
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.
Re: dCount query - 09-10-2006 , 01:41 PM
"Blue Lagoon Products - Customer Services"
<info (AT) bluelagoonproducts (DOT) com> wrote in
news:ESYMg.20197$89.14547 (AT) fe1 (DOT) news.blueyonder.co.uk:
table, including duplicates are greater than 2.
What you need is
"[Buyer id] = " & me.txtBuyerID & ")"
if [Buyer ID] is a number.
"[Buyer id] = """ & me.txtBuyerID & """)"
if it's in a text field in the table.
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.