Looking to make a query based on dates entered into a form. Here is what I have and its not working:
SQL View:
HAVING (((Recap.Date) Between [Forms]![State Mileage Finder]![Starting Date] And [Forms]![State Mileage Finder]![Ending Date]));
Here is what I entered into the Criteria field in Design View:
Between [Forms]![State Mileage Finder]![Starting Date] And [Forms]![State Mileage Finder]![Ending Date]
What am I doing wrong?
SQL View:
HAVING (((Recap.Date) Between [Forms]![State Mileage Finder]![Starting Date] And [Forms]![State Mileage Finder]![Ending Date]));
Here is what I entered into the Criteria field in Design View:
Between [Forms]![State Mileage Finder]![Starting Date] And [Forms]![State Mileage Finder]![Ending Date]
What am I doing wrong?