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.
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.