Use Same Parameter For Different Fields Within Query?

  • Thread starter Thread starter DanielWalters6
  • Start date Start date
D

DanielWalters6

I'm trying to build a query which asks for one parameter "SEARCH TERM", and
locates records from one table, where the string "SEARCH TERM" is found
anywhere within any of three fields.

ie. Product List - Has Product Code, Name and Description fields.

I would like one parameter box to be displayed and have it search all three
fields within the table to return any records that meet the criteria.

Any suggestions would be appreciated.

Dan Walters
 
You can reuse the parameter under different fields.

In the Criteria row under the first field, enter:
Like "*" & [SEARCH TERM] & "*"

Under the next field, repeat the expression on first OR line, i.e. the one
*below* the Criteria line in query design.

Under the 3rd fields, repeat it on the 2nd OR line.
 
Back
Top