Prompt for <= Date and Press Enter for All

J

jhicsupt

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

Thanks in advance.
 
O

Ofer Cohen

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
 
Top