EDIT: Sorry wrong Title, Should be: Query Count number of days not total number of days.
I am new to Access, and am having several problems I am have been spending several days trying to resolve. I will start with this one first.
Table query is made: [ID], [CheckinDate], [Call] [QNI], [QTC] note: QNI / QTC are YES/NO)
Query Results Example:
[ID], [CheckinDate], [Call] [QNI], [QTC] [Sessions] <<<(Sessions in not the table, I created in query. >>> Sessions: (Day([CheckinDate])))
[1], [11/04/2013], [AAAA] [-1] [0] [4]
[2], [11/04/2013], [BBBB] [-1] [-1] [4]
[3], [11/11/2013], [CCCC] [-1] [1] [11]
[4], [11/11/2013], [DDDD] [-1] [0] [11]
[5], [11/11/2013], [EEEE] [-1] [-1] [11]
When I count(*) by Date, I get (5), I want an answer of (2)
Can I get this results in query or do I have to do in report? How?
Do I need the [Sessions] field?
I want a query and Report to end with this result: QNI: 5, QTC: 3, SESSIONS: 2
Thank you,