match record on criteria if none present match different

[ali32j]

Hi all

I have a query which i want to filter down, as follows:

code i have at moment is

SELECT Customer.[Name 1], Customer.[R/3 Acc Group]
FROM Customer
WHERE (((Customer.[R/3 Acc Group])="soldto"));

But this will only return soldto, i want it to look for soldto, if none present for each customer then filter the shipto

Is this possible? if so can anyone help?

Thanks

Ali

 

[r937]

SELECT Customer.[Name 1]
     , Customer.[R/3 Acc Group]
  FROM Customer
 WHERE Customer.[R/3 Acc Group] IN ('soldto','shipto')

r937.com | rudy.ca
Buy my new book Simply SQL from Amazon

 

[ali32j]

Hi r937

Thanks for your help

Ali