Smart Parameter Query

A

acss

I would like my parameter query to provide all records if left blank or if
the end user only knows the first 3 letters of a name then it should records
with that criteria. Can this be done?
 
M

Marshall Barton

acss said:
I would like my parameter query to provide all records if left blank or if
the end user only knows the first 3 letters of a name then it should records
with that criteria. Can this be done?


Try setting the name field's criteria to something like:

Like [Enter start of name] & "*"
 
Top