Greetings:
Newbie here. I have created a query to pull all the records from a start date and an end date. Also in this query I want to only see the appointments we did not miss. I created the query and under the date column
Between [Start Date] AND [End Date] to prompt the user to enter dates. Under the Appointment column I enter "NotMissed".
I can run the Not missed with no problem, but the dates will not run. What am I doing wrong???? Help!!