Simple Query Question

[tonysh]

Not so simple for me apparently, but I don't use Access too often so...

I have a query and want to run it dependant of user's input. All is well so far as I enable users to enter their criteria for one of the fields via square brackets. Now, what I want is if they leave it blank, the query should return all records. I'm pretty sure it's possible.

TIA,

Tony.

 

[giacomo]

try using this as your criteria:

LIKE [enter criteria here] & "*"

hth,
Giacomo

 

[tonysh]

Hey Giacomo,

Thanks a bunch. It works fine now.