Query Design View Criteria

[ChrisHallJJ]

I have a query that I am having trouble with my seletion criteria. I have a table that has mulitple fields that I want to select if any one of them contain a value. I don't know how to define this in the design view...it keeps "ANDing" the fields instead of "ORing" them. When I only have two fields, it seems to work if I put one value on the "criteria line" and one on the "OR line".
Thanks in advance,
Chris

 

[PHV]

You may have many "OR line"...

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[ChrisHallJJ]

I am having trouble figuring out how to do this......
Chris

 

[PHV]

menu Insert -> Lines

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[TheAceMan1]

How are ya ChrisHallJJ . . .

To [blue]OR[/blue] the fields just dropdown a line for each. Example:

[blue][tt]  Field1      Field2      Field3      Field4      Field5
*********** *********** *********** *********** ***********
Is Not Null                                     
                        Is Not Null
                                                Is Not Null[/tt][/blue]

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886

 

[ChrisHallJJ]

Thank you...I did finally get this to work..I thought it wasn't, but found out my unexpected results was due to data. Chris