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!
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!