Query Criteria Select

**angie** · 07-31-2016, 02:40 PM

I have a query that I use the following criteria ( like*"tech*") I would like to use this query in a report I would like to select what item to select using the like because there will be three items in the field and I am only wanting the item selected to show.

so I tired like*[select]* but that doesn't work.

**CJ_London** · 07-31-2016, 03:17 PM

try

like "*" & [Select Option] & "*"

**angie** · 07-31-2016, 03:21 PM

Works great thanks !
could I have the selected name show on the report in the header ?

Query Criteria Select

Thread Tools

Query Criteria Select

Similar Threads

Return Value in Select Query based on criteria in another column of Query

Multi Select List Box selecting Query Criteria, Criteria come up with quotation marks

Using a form as a criteria in a select query

Select Query on Criteria or Blank?

Select query with two criteria

Posting Permissions