Criteria over several fields?

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

Guest

I would like to run an "or" criteria over several fields where if particular
data shows up in any of three fields, that record will be selected. How can
that be done?
 
Photomom2a said:
I would like to run an "or" criteria over several fields where if
particular data shows up in any of three fields, that record will be
selected. How can that be done?

In the query design grid put the criteria under all three of the fields but
on separate rows. That gives you an OR. When multple criteria is on the
sam line you get an AND.
 
That is exactly what I did, but it still does not choose the record. I don't
know what I'm doing wrong. Should I start on the "or" line or on the
"criteria" line for the first field in the series?
 
Start on the criteria line.
Keep in mind that if you have criteria in only one field in a row, the
criteria for the other two fields dos not apply for the records returned by
that row. Only criteria in fields on the same row apply.
 
When I have the selected criteria starting in the "or" row it doesn't limit
selections. When it starts in the "criteria" row, it limits it to only the
ones that have that selection in that field--it doesn't look in the other
fields although the data is on their "or" rows.
 
I am looking to return records with data in any of four fields. I do not
want to exclude or bypass any fields.
 
copy your SQL and post it here.


Photomom2a said:
When I have the selected criteria starting in the "or" row it doesn't limit
selections. When it starts in the "criteria" row, it limits it to only the
ones that have that selection in that field--it doesn't look in the other
fields although the data is on their "or" rows.
 
Back
Top