I need a wildcard to let me look for all the value in a field

[Guest]

I need a wildcard to let me look for all the value in a query in a specific
field, asking me for something and I may type any character and the use of *
or ? to retrieve them, but different anytime. EX: This time I want all
the customers that contain P* on the field, but next time I want customers
that contain C* and so on.
I'm using Access 2003.

 

[John Spencer]

Field: SomeField
Criteria: LIKE [Find What]

Then you type in the search string including the wild card(s).

Field: SomeField
Criteria: LIKE [Find What] & "*"

You type in what characters you want to find "C" or "P" and the wild card is
automatically appended to the end of your string.

If you want to find all records that contain the string, then the criteria
should read LIKE "*" & [Find What] & "*"

 

[Ken Snell \(MVP\)]

SELECT *
FROM TableName
WHERE FieldName Like [Enter first letter:] & "*";

 

[Guest]

Try using this as criteria --

Like [Enter customer] & "*"