like[]*

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

Guest

I want to create a query with the criteria set [Please enter critiera]
brackets[] but i want to set the criteria to be Like[] with the * wild card
i.e.

when it says 'please enter criteria' i can enter an Abbreviation and it will
find all the records????????

Thanks for any help
 
In the query builder, put

Like "*" & [Please enter criteria] & "*"

in the Criteria cell under the field in question.
 
Back
Top