Select by first three digits

A

acss

I would like my parameter query to bring back records by the end user typing
the first three letters of a description. There should also be the option of
leaving the parameter blank to return all records. Can this be done?
 
S

Stefan Hoffmann

hi,
I would like my parameter query to bring back records by the end user typing
the first three letters of a description. There should also be the option of
leaving the parameter blank to return all records. Can this be done?
Click to expand...
Use the following criteria

[yourField] LIKE Nz([yourThreeLetters], "") & "*"



mfG
--> stefan <--
 
D

Dennis

In the criteria row of the relevant field in your query put this

Like [Enter Start Text] & "*"

This will allow you to type any start characters (more or less than 3 if you
wish)
or enter nothing to bring back everything.
 
A

acss

Thanks, that did it!

Stefan Hoffmann said:
hi,
I would like my parameter query to bring back records by the end user typing
the first three letters of a description. There should also be the option of
leaving the parameter blank to return all records. Can this be done?
Click to expand...
Use the following criteria

[yourField] LIKE Nz([yourThreeLetters], "") & "*"



mfG
--> stefan <--
Click to expand...
 
Top