Help - access querying!

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

Guest

hiya,
need some help, im trying to run a query whereby i need to search for "X" in
multiple fields, field A, field B, field C AND field D! if the query finds
"X" in atleast one field the query will display the entirity of the record!
any ideas how i can set this up?
 
Hi,
Create a new query, selecting all fields in record. In the query
criteria, you want to enter X for the fields that you are interested in. The
trick is to enter on different lines, which will give you "OR" logic. It
should look something like this:

field A field B field C
X
X
X

This means, return the record if field A = X or field B = X or field C = X.
Hope this helps.
 
Back
Top