Comparison query year1 to year2 ??

  • Thread starter Thread starter John
  • Start date Start date
J

John

I am trying to design a query that finds the customers that ordered from us
in 2002,
But didn't order from us in 2003.
I have two related tables.
tblCustomers tblOrders
CustID OrderID
Fname CustID
Lname OrderDate

Obviously I can design queries to find orders in each year, but I am at a
loss as to how to do a comparison or differentiate or whatever it's called.
I need to know who ordered one year but not the next so I can solicit them
as to why.
Any ideas?

Thanks for any help
 
-----Original Message-----

I am trying to design a query that finds the customers that ordered from us
in 2002,
But didn't order from us in 2003.
I have two related tables.
tblCustomers tblOrders
CustID OrderID
Fname CustID
Lname OrderDate

Obviously I can design queries to find orders in each year, but I am at a
loss as to how to do a comparison or differentiate or whatever it's called.
I need to know who ordered one year but not the next so I can solicit them
as to why.
Any ideas?

Thanks for any help


.
Click to expand...
Reply.

One way would be do make 2 queries (one for each year)
then run an (Find Unmatched query wizard) then follow the
prompt.

Regards

Ian
 
Back
Top