Hi everyone.
I have query with criteria based on two dates (txtStartDate, txtEndDate), The query has the following criteria:
Between [Forms]![frmFormNameDialogue]![txtStartDate] And [Forms]![frmFormNameDialogue]![txtEndDate]
If the dates are selected, the query will run and display the record based on the condition.
What I want is:
Show all records if no dates are specified.
How can this be done?
Khalil