Criteria to queries

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

Guest

Hi
I have a query which contains many data. I want to ask me base a criteria
what data to show me. For example ask the user to enter the contact name in
order to show the other data. But this is difficult because there are a lot
of names and you have to remember it exactly how is writting in order to show
the other information. If you dont write the contact name correct it doesn't
find any data.
I want to ask if there is a simpler way to to that with wildcards maybe??

Pls help me

Thanks a lot
 
Instead of using a criterion like:

[Enter Contact Name]

which only works with an exact match, use instead:

Like "*" & [Enter part of Contact Name] & "*"

which will return all record containing the part of the name entered, so
"Smith" will return Smith, Smithson, J.A. Smith etc.

HTH,
Nikos
 
Back
Top