By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,686 Members | 2,770 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,686 IT Pros & Developers. It's quick & easy.

Query help needed, Urgently!

P: 14
Hi everyone,

i'm new to this forum and new to using ms access.

I have a cleint table in a database, i want to be able to query that table to get details for one particular client.

I've set the criteria in the query as [Enter Client's Name], so when i click the query button i'm prompted to put in the client's name, then the details for that client appears. that works fine.

my problem is that when i am prompted to put in a client's name, eg. Applenovia Co., i want to be able to put, eg just A, or App, or Applen (in the event that i dont remember how it is spelt) in the prompt, and it should auto complete the name for me, i click ok, and i should get details for Applenovia Co.

Can anyone help me please? It would be greatly appreciated. Thanks!
Sep 29 '06 #1
Share this Question
Share on Google+
4 Replies


P: 4
Hi everyone,

i'm new to this forum and new to using ms access.

I have a cleint table in a database, i want to be able to query that table to get details for one particular client.

I've set the criteria in the query as [Enter Client's Name], so when i click the query button i'm prompted to put in the client's name, then the details for that client appears. that works fine.

my problem is that when i am prompted to put in a client's name, eg. Applenovia Co., i want to be able to put, eg just A, or App, or Applen (in the event that i dont remember how it is spelt) in the prompt, and it should auto complete the name for me, i click ok, and i should get details for Applenovia Co.

Can anyone help me please? It would be greatly appreciated. Thanks!
Try Like "*" & [Enter name :] & "*"

MalcR
Sep 29 '06 #2

P: 14
Try Like "*" & [Enter name :] & "*"

MalcR

Thanks a lot MalcR, it worked.
Sep 29 '06 #3

100+
P: 143
Use the LIKE operator in the criteria of your query. It won't act like a combo box however, as a query only returns those records that fulfill the criteria.

Like "*" & [Enter a name] & *"*
Will give you all records with your criteria in the name and

Like [Enter a name] & "*"
will give your all records starting with your criteria.
Sep 29 '06 #4

P: 14
Use the LIKE operator in the criteria of your query. It won't act like a combo box however, as a query only returns those records that fulfill the criteria.

Like "*" & [Enter a name] & *"*
Will give you all records with your criteria in the name and

Like [Enter a name] & "*"
will give your all records starting with your criteria.

Ahhh...solves my problem! Thx
Sep 29 '06 #5

Post your reply

Sign in to post your reply or Sign up for a free account.