use Like after prompting for a value? 1

[Lost500]

Hi all,
I am trying to make a query where it prompts for the first couple of letters of a value and then returns values that match. I'm trying things like:

Like [enter the first three letters of the unit]*

I know thats way wrong, and if i didn't access let me know very quickly, also i'm working in the query builder but the sql will work great also. Thanks for any help in advance!

 

[GingerR]

Like [enter the first three letters of the unit] & "*"

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at

http://r937.com/relational.html

 

[Lost500]

Thanks GingerR That worked great!