Prompt for <= Date and Press Enter for All

[Guest]

In a query, how do I prompt for Ending Date? I want to also press Enter to
return all records.

Thanks in advance.

 

[Guest]

Try something like

Select * From TableName Where DateFieldName <= [Please enter Ending Date]
Or[Please enter Ending Date] Is Null

adding the date criteria as a field with Is Null for it's criteria