starting letter

[tonymat]

I want a criteris in access to get the records having field 2 starting with "num". Num is example. I want to do withdifferent letters.

number
numbiur
numg
numds

the first three letter should be num in this example. i want for different words i.e, i need to enter the paramter message box.

 

[FoFa]

Using your example, in your criteria it would be
field2 LIKE "num*"

 

[Rebel]

To expound a little bit, if you want a pop-up box asking for the criteria, enter the following in the criteria field of your query:
LIKE [Enter first 3 letters: ] & "*"