I have a form which feeds a query with a start date and an end date.
In Query design, I use Between to limit the range of records to the requested date range.
If the user chooses NOT to fill in the 2 dates text boxes on the form, can I use Like & * together with my Between criteria in the query design?
I'm not sure what the proper syntax would be. Any suggestions?
In Query design, I use Between to limit the range of records to the requested date range.
If the user chooses NOT to fill in the 2 dates text boxes on the form, can I use Like & * together with my Between criteria in the query design?
I'm not sure what the proper syntax would be. Any suggestions?