Search using Query

[harringg]

I've got a table with multiple fields per record.

I want to pull up data in a form using a Query.

A term may reside in either the "Notes" or "Comments" field.

To search for "coffee" in the Notes field, I'd set a criteria in the Query builder:

Like "*" & [Enter Your Beverage] & "*", under the Notes Field in the query builder. It would prompt me to enter a text string when running the query. All is good.

If I want to enter "coffee" once and have it return records that contain that word in the Notes or Comments field, what would the syntax be?

Access 2003

 

[boblarson]

Put the same exact criteria on the OR line of the comments field. If the exact same parameter prompt is used, it will only prompt you once for it.

 

[harringg]

Put the same exact criteria on the OR line of the comments field. If the exact same parameter prompt is used, it will only prompt you once for it.

That worked as I was hoping for.

Thanks for the reply.