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

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

Guest

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.
 
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.
 
Back
Top