Do not include row in union query if field contains a 0 value

[Bertrand82]

Hi,



I have a union query wich collects data from differents excel sheets.

I would like the union query to exclude rows that contains a 0 in a specific field with name [Company].

Is there a code or other function?
If code where do I put the code?

Br Bertrand

[JoeM]

Add a Where clause to each subquery in the Union query that excludes those records, i.e.

SELECT ...
FROM ...
WHERE Company<>"0"

UNION

SELECT ...
FROM ...
WHERE Company<>"0";

(assuming company is a text field, if it is numeric, remove the quotes from around the zero).

[Bertrand82]

Thank you!