parameter query

[jojostar]

I am trying to write a parameter query to do a partial name search. Right now I have a parameter query that prompts the user to enter in the Applicant's last name and the user needs to enter the name exactly as spelled. Under criteria in the query I have [Enter Applicant's Last Name:].

Is there a way to change this so the user can enter the first few letters of the last name and find the Applicant?

Thanks

 

[Full_Williams]

Try using Like <text> * in your criteria.

 

[jojostar]

Where do I put that in in my language [Enter Applicant's Last Name:]?

 

[Full_Williams]

Put "Like [Enter Applicant's Last Name:]" in your queries criteria.

The sql will look something like this:

SELECT tblApplicants.LName
FROM tblApplicants
WHERE (((tblApplicants.LName) Like [Enter Applicant's Last Name:]));

Hope that helps.

 

[jojostar]

I tried that and it returns no records. Like [Enter Applicants Last Name]. Is that what you were thinking? I am sure I am close....

 

[Full_Williams]

Yes that's what I'm thinking. You might try using

Like [Enter Applicants Last Name]*

Also, try looking up "Like" in help.

Let me know if you get it.

 

[jojostar]

No luck. Any other suggestions? I would think this is a common dilemma?

 

[Full_Williams]

Try putting the "*" inside the "[]" at the end of the name.

 

[jojostar]

No luck. ugh!

 

[Full_Williams]

Did you try putting say "P*" when prompted for [Enter Applicants Last Name]?

This should bring up all last name that start with P.

 

[jojostar]

That was my first try and that did not work either.

 

[Full_Williams]

If your application isn't too big you can send it to me at

robertgrabowski@hotmail.com

and I'll take a look.

 

[jdewell]

In the query criteria section, type Like "*" & [Enter Applicant] & "*"

 

[jojostar]

BINGO!!!! Thank you! You are a life saver (and time saver)