Darrell
Registered User.
- Local time
- Today, 19:34
- Joined
- Feb 1, 2001
- Messages
- 299
I have a form which inputs the parameters of a query such as Start Date, Finish Date, Shift Number, Machine Number etc...
What I would like to know is, is there a way to have all of the data selected from a query if one or more of these parameters are left blank.
ie, if I selected a Shift Number and Machine Number and left the date fields blank, could I get all of the records relevant to those parameters regardless of the date?
What I would like to know is, is there a way to have all of the data selected from a query if one or more of these parameters are left blank.
ie, if I selected a Shift Number and Machine Number and left the date fields blank, could I get all of the records relevant to those parameters regardless of the date?