how do i set up a query that typing first three letters give me t.

Q

qamar syed

I am a new user of of ms access. I am working on only one table with 5 fields
and would like to know how can i view two fields (one text and one number)in
query mode by typing first three letters in a prompt box to get the whole
word in one field.
 
A

Al Campagna

Qamar,
Use the following criteria against the text field in your query. (like Country for
ex.)

Like [YourInputBoxText] & "*"

If you enter "chi" in the input box the query would return China.
 
Top