Query for same value in multiple fields

  • Thread starter Thread starter ron
  • Start date Start date
R

ron

A have a table with three "type of service" fields and
three corresponding dollar amount fields. The type of
service values are pulled from drop down menus of ten
choices and the dollar amounts are entered manually. In
any given record the value of a type of service will occur
only once. (i.e. if [TypeOfService1]="repair", then
[TypeOfService2] and [TypeOfService3] will never
be "repair."

I need to create a query that will allow me to pull all
records where "repair" occurs in any of the fields
[TypeOfService1], [TypeOfService2], or [TypeOfService3].
Putting "repair" as criteria for all three fields
obviously doesn't work since it creates an AND statement
which will always return zero records.

Can someone help me out here?

Thanks,
ron
 
In the Query grid note that there are a number of rows
below Criteria. The first row below Criteria invokes OR.
Put your first "repair" on the Criteria row in
TypeofService. For Type of Service2 put "repair" on the
next row down, etc.
Roxie Aho
 
Hi Ron:

Build the query putting "repair" in the criteria line of the first field,
then move down a line ("OR") and put "repair" under the next field, move
down a line ("OR") and put "repair" under the last field. This should build
the "OR" statement you want.

Hopefully, I explained this well enough. Good luck to you.
S. Jackson
 
Back
Top