Select by first three digits

  • Thread starter Thread starter acss
  • Start date Start date
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?
 
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 <--
 
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.
 
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...
 
Back
Top