Query to ignore other conditions

[sunilkeswani]

Hi

I have a query that has 4 different fields, with numbers in them..I
want it to pull out all records which have the number 1 in ATLEAST one
of the four selected fields.

Please advise

Cheers
Sunny

[Allen Browne]

WHERE ((Field1 Is Not Null) OR (Field2 Is Not Null) OR (Field3 Is Not Null)
OR (Field4 Is Not Null))

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

<su**********@gmail.com> wrote in message
news:11**********************@g14g2000cwa.googlegr oups.com...

I have a query that has 4 different fields, with numbers in them..I
want it to pull out all records which have the number 1 in ATLEAST one
of the four selected fields.

Please advise

Cheers
Sunny

[sunilkeswani]

Thanks Allen, I am looking for it to pull out a specific series of
numbers like 522,523,597,600 . If any of these 4 numbers are present
in any of the 4 columns, I want all these records to be displayed.

[Allen Browne]

WHERE (Field1 IN (522, 523, 597, 600)
OR Field2 IN (522, 523, 597, 600)
OR Field3 IN (522, 523, 597, 600)
OR Field4 IN (522, 523, 597, 600))

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

<su**********@gmail.com> wrote in message
news:11**********************@g47g2000cwa.googlegr oups.com...

Thanks Allen, I am looking for it to pull out a specific series of
numbers like 522,523,597,600 . If any of these 4 numbers are present
in any of the 4 columns, I want all these records to be displayed.

[sunilkeswani]

Thanks Allen, sorry but could you please provide the complete code? the
SELECT XX from XX ?
I am no good at this, but I need to get this working..

Cheers

[Allen Browne]

1. Create a query that selects the fields you want from the table(s) you
want.

2. type anything into the Criteria row under one of the fields.

3. Switch the query to SQL View (View menu).

4. Replace the line containing:
WHERE ...
with the WHERE clause from the previous post.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

<su**********@gmail.com> wrote in message
news:11**********************@o13g2000cwo.googlegr oups.com...

Thanks Allen, sorry but could you please provide the complete code? the
SELECT XX from XX ?
I am no good at this, but I need to get this working..

[sunilkeswani]

That helps, thanks Allen