I have a form called frmEarnings with 2 text fields txtStart and txtEnd
The user is forced to specify a date range to retrieve data from the database however I have an anomaly that I can not explain.
In the report query I have a field called sl_date and have the following for my criteria:
>=[Forms]![frmEarnings]![txtStart] And <=[Forms]![frmEarnings]![txtEnd]
If the user enters the same start date and end date, for example wants daily sales, it just gives a blank report.
Why is that? The formula above makes sense to me logically but it does not work.