Wildcards in parameter queries

[KristianAA]

How do I make it possible for a user of a access 2003 db to use wildcards in
a parameter query? I.e. entering Nicolas will make the query list all records
with Nicolas in a particular field - a field that can contain several names.
Entereing let's say *Nicolas* doesn't do the trick.

 

[Jerry Whittle]

Something like the following in the criteria:

"*" & [Enter the First Name] & "*"

 

[KARL DEWEY]

Criteria like this --
Like "*" & [Enter name] & "*"

 

[Jerry Whittle]

Karl's is correct. I forgot the LIKE
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

Something like the following in the criteria:

"*" & [Enter the First Name] & "*"
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

How do I make it possible for a user of a access 2003 db to use wildcards in
a parameter query? I.e. entering Nicolas will make the query list all records
with Nicolas in a particular field - a field that can contain several names.
Entereing let's say *Nicolas* doesn't do the trick.