Quary potential customer from tblCustomers

  • Thread starter Thread starter Simon
  • Start date Start date
S

Simon

I have a Table with current customers and potential customer in it. I
then have a table of orders.

I want a query what will only show potential customer and not current
customer.

Could any one point me in the right direction on how to do it as i can
not think of the bes way

Thanks

Simon
 
Assuming potential customers do not have any orders:

Queries->New->Find Unmatched Query Wizard->follow the directions...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Show every customer even if mobile in null 2
searching over multiple tables 1
Query to show all cutomer that placed an order 4
How do I click on a subform to bring up the corresponding record? 6
Mail Merger from Access to word 1
Starlink Extends LEO Satellite Broadband Coverage in the UK 1
One to many relationship 33
Create New Table/Column 1

Back
Top