Report/Query Count help

[DOC]

I am using access 2007.


This is an example of a weekly attendance report/query I do.
The QNI & QTC are Yes/No fields.
I can get the NAME, QNI, & QTC totals.
I cannot get the Sessions to equal 3, I get 9 for an answer.
If I can do away with the "Sessions" that is good,
if CheckinDate column can total 3 that would be better.
Can I get the results in a query? or does it only come from a report? Both?
Can anyone help me?

CheckinDate	NAME	QNI	QTC	Sessions: (Day([CheckinDate]))
11/2/2013	JOHN	-1	0	2
11/2/2013	FRED	-1	1-	2
11/2/2013	DOUG	0	0	2
11/9/2013	JOHN	0	0	9
11/9/2013	FRED	-1	0	9
11/9/2013	DOUG	1-	1-	9
11/16/2013	JOHN	-1	0	16
11/16/2013	FRED	-1	0	16
11/16/2013	DOUG	0	0	16
TOTAL:	9	6	2	3

[orange]

What is the SQL of your query?

Can you tell us in plain English what you want your query to do?

I cannot get the Sessions to equal 3.

But your total for Sessions is 3????

[DOC]

The above is an illustration I built to show what I want a a final result.
I can get totals for [NAME]=9. [QNI]=6, [QTC]=2. But I cannot get [Sessions] to equal 3. I get 9.

The SQL below is as shown on my screen.

SQL:
SELECT tblNetArchive.NetID, tblNetArchive.Call, tblNetArchive.CheckinDate, tblNetArchive.QNI, tblNetArchive.QTC, (Day([CheckinDate])) AS Sessions
FROM tblNetArchive
GROUP BY tblNetArchive.NetID, tblNetArchive.Call, tblNetArchive.CheckinDate, tblNetArchive.QNI, tblNetArchive.QTC, tblNetArchive.ID, Year([CheckinDate]), Month([CheckinDate])
HAVING (((tblNetArchive.NetID) Like "NMPN") AND ((Year([CheckinDate]))=[What Year?]) AND ((Month([CheckinDate]))=[What Month?]))
ORDER BY tblNetArchive.ID;

[orange]

I think you are trying to get a count of sessions grouped by CheckinDate. That is in the other fields you have the detail items but for sessions it appears you want a cOUNTof seSSION Grouped by CheckinDate... There are 9 session detail records, but there are 3 sessions if you group bu CheckinDate, and there are 3 sessions if you group by Name..

[June7]

How are you generating those totals? Are they calcs in report footer section? Set up a group section in the report and do calcs in group footer.

[DOC]

I tried running a report, making a group with the "Sessions" field. It looked like it should work as the "2", "9", and "16" separated in the report, but I don't know the formula.
I still couldn't get it to count the days to get (3), counted the number of records.

[June7]

Have to group on the date or on the name fields to get the group count of 3 for each.