Wildcards

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

Guest

How do I set up a wild card query to look for names "Like" in the data base.
If I'm looking for a customer it could start with any letter of the alphabet.
Also, if I have the customer number, how do I find that customer for future
orders using a wildcard character -- same thing, I guess, but all our numbers
start with a different letter. I'm in the process of developing a data base
that is needed this month and I'm learning access as I go. Any and all help
is appreciated. Thank You
 
Enter the following in the criteria and when you run the query it will
prompt the user to enter part of the name. It will then look for any
records that contain that string.


Like "*" & [EnterPartialName] & "*"

Use similar code for the number. You can leave off the last &"*" if you
want to find entries that end with what the user enters.

Rick B
 
Back
Top