Check to see if customer exists

[Blue Lagoon Products - Customer Services]

Hi,

We have an inhouse database that I designed in access 2000 with the help of
all you guys some time ago. It stores orders and prints packing slips etc.

I would like to put onto the packing slip wether this is a new customer or
an existing customer. We do have a customer table, just one table for
customer details, orders, notes etc, this is what works best for us as data
is imported from payment files...anyway...

I require code that will lookup the 'Buyer_ID' in tblDownload and if it has
2 or more records of that buyer ID, then a label to say 'Existing Customer'
on the report. Would anybody be able to help me?
--

Thank You,

Nick Jones
Customer Services
Blue Lagoon Products

[pietlinden]

use an unbound control on your Packing Slip report and use DCount() on
the customer table and check that the result is >1.
(Not at my computer, so I'm going to wing this and probably do it
wrong).

IIF(DCount("CustomersTable","CustomerField")>2,"Ex isting Customer",
"New Customer")

the basic idea (since my code is no doubt wrong, but you can get the
right syntax from Help) Using DCount with give you the number of
records in the table that match the criteria specified (Count of
CustomerField>2). You can use that to determine which note to show on
your report. Just create an unbound control and put in the iif
statement.