Base trouble with critirion in a query

[pascale]

Hi,
I am having trouble with the results of a query, here is the sql;

SELECT "EBSales"."shades", "EBSales"."Prix de vente" AS "EU TTC Devise", "EBSales"."NDT", "EBSales"."Quantité", "EBSales"."Payé le" AS "Date", "paypal"."Rate", "Quantité" * "Prix de vente" * "Rate" AS "EU TTC €", "EBSales"."Pays" FROM "EBSales", "paypal" WHERE "EBSales"."NDT" = "paypal"."NDT" AND ( "EBSales"."shades" IS NOT NULL AND "EBSales"."Pays" = 'Royaume-Uni' OR "EBSales"."Pays" = 'Malte' OR "EBSales"."Pays" = 'Irlande (Eire)' OR "EBSales"."Pays" = 'Grèce' OR "EBSales"."Pays" = 'Allemagne' OR "EBSales"."Pays" = 'Chypre' OR "EBSales"."Pays" = 'Pays-Bas' OR "EBSales"."Pays" = 'Danemark' OR "EBSales"."Pays" = 'Suisse' OR "EBSales"."Pays" = 'Italie' OR "EBSales"."Pays" = 'Luxembourg' )

And here is a screen shot

In the first column “Shades” I only want to see rows which have a LS number ie “IS NOT EMPTY” but for certain countries in my list that are part of the eu appear!.

I have changed the “OR” for “AND” which left a blank table, and I have gone into “query properties” and changed the distinct values to yes but this only added more rows with the first column empty.
Any Ideas???
kind regards
Paul

NB, I have another query with only one country that work great

[Ratslinger]

Here is what I understand you want. Three conditions for the selected criteria.

• “EBSales”.“NDT” = “paypal”.“NDT”

AND

• “EBSales”.“shades” IS NOT NULL

AND with both of those only if it is one of the eleven countries specified by the OR statements.

If that is the case it is a problem with the grouping of your conditions. After this portion or your statement

 ("EBSales"."shades" IS NOT NULL AND

enclose the remaining OR conditions with an added set of parenthesis.

[pascale]

Ooooooo mr @ratslinger you are magic!!! I knew it would be something simple, (but still far to complicated for me!) Thank you so much.
Kind regards
Paul