Parameter Query and Criteria

  • Thread starter Thread starter Comanchace
  • Start date Start date
C

Comanchace

I was thinking of making a parameter query. The Criteria
im using is something like:=
[Enter your username]. This means that you have to type
the exactly username or it will appear nothing. For
example if the name John Mcnroe is in the database and if
you type John it will appear no results. You have to type
John Mcnroe. And i wanted you to type John and appeared
all the John´s in the database. It´s some function i have
to put in the criteria similar to = but i don´t know wich
is. Can you please help me on this?

Thanks
 
Try this in your criterion:

Like "*" & [Enter your username] & "*"

This will pick-up records containing the inputted text string in any
position (beginning, middle or end).

HTH,
Nikos
 
Back
Top