I have a report that where I want the starting and ending dates to be determined based on user input on a form. The between statement works fine when both the starting and ending date fields have been filled out, however I would like more flexibility. What I’d like is to handle each of these scenarios:
If the user leaves both date fields blank on the form, I’d like to show all records.
If the user enters only the starting date, I’d like to show all records >= the starting date.
If the user enters only the ending date, I’d like to show all records <= the ending date.
If the user enters both a starting and ending date, show all records between those dates.
Thanks!
Vernon
