Unanswered: Count dates matching criteria in MS Access
I have a query that looks like this:
Name Date1 Date2 Date3 Date4
John 13-Jan-07 20-Jan-07
Sam 16-Jan-07 18-Jan-07
Mike 21-Nov-06 16-Jan-07 18-Jan-07 20-Jan-07
The query is designed to list all customers who have had appointments on dates ranging from 16-Jan-07 to 20-Jan-07. My intent is to program Access to calculate for me in a report how many times customers had visited the office from 16-Jan-07 to 20-Jan-07. The answer, according to this example, would be 6.
Thank you in advance for your help.
I apologize for the confusion. I want to count how many visits were on 16, 18, and 20 Jan only since this time period represents a week when our office is open. I would like to be able to display a report that lists this number for me. I created a text box with the following expression to count the visits in the date1 field that equal 16-Jan:
Is there a way for me to write a SQL statement that would simply count the visits that occurred from 16-Jan to 20-Jan? There are eight date fields: date1, date2.....date8. If so, where do I write the SQL statement? Do I create a text box and write the statement in the control source of the date tab? I'd appreciate any help you can provide. Thanks so much for the support.