J
John Hipskind
I've created a dialog box to feed Criteria to a parameter
query, which is the basis for a customizable report.
The dialog box contains all of the fields of the query.
I'd like the user to have the flexibility to enter values
in one, two, or as many of the fields as he chooses,
leaving the others empty.
Example:
I have 3 fields: First Name, Last Name and Age.
How do I enter a First Name and an Age of 34 to find all
people named "John" who are 34 years old?
As I currently have it set up, if I leave any of the
fields empty in the dialog box, I get a null query.
Please advise.
Thanks.
John
query, which is the basis for a customizable report.
The dialog box contains all of the fields of the query.
I'd like the user to have the flexibility to enter values
in one, two, or as many of the fields as he chooses,
leaving the others empty.
Example:
I have 3 fields: First Name, Last Name and Age.
How do I enter a First Name and an Age of 34 to find all
people named "John" who are 34 years old?
As I currently have it set up, if I leave any of the
fields empty in the dialog box, I get a null query.
Please advise.
Thanks.
John