Return all customers who have never placed an order via a particular sales method

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

I have a Customers table and an Orders table. A CustomerNum field links the
two tables. The Orders table has a Source field containing a number that
indicates how the order was placed (1=web, 2=email, 3=phone, or 4=fax).

I need to generate a report containing all customers who have *never* placed
an order via the web.

I can write a query to return all non-web orders...and then determine the
associated customers; but that doesn't assure that those customers have *no*
non-web orders.

How can I return the correct information? Thanks!
 
Solve by the inverse. Find all of those that HAVE ordered via those
internets, then use that list to deduce who hasn't.

Next, find all customers that have never placed an order.(Don't want to
forget them.)
 
Back
Top