Query based on multiple criteria

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have 2 fields in a purchase order table [Customer], [Completed] y/n

I want to query for all customers except one Specific Customer if that
Specific Customer has completed.

In other words, Not "Specific Customer" if [Completed] = Yes

Please help with the expression and where to put it.

Thanks,

Yuta
 
yuta10 said:
I have 2 fields in a purchase order table [Customer], [Completed] y/n

I want to query for all customers except one Specific Customer if that
Specific Customer has completed.

In other words, Not "Specific Customer" if [Completed] = Yes

Please help with the expression and where to put it.
Click to expand...
Hi Yuta,

One solution might be to filter
for the "positive case"

WHERE
(Customer <> "Specific Customer")
OR
(Customer = "Specific Customer"
AND
Completed = No)
 
Back
Top