Prompt for <= Date and Press Enter for All

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Thanks in advance.
 
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
 
Back
Top