Making text box link with a session

[callylj]

I have made a form in which a session shows the attendance of members (which is in a subform), where attendance is shown by ticking a box (also in the subform).

The thing is for each session when i use the DCount formula it adds up all of the ticks in tick boxes in the whole subform, not just the ticks in the tick boxes in the subform that are linked to the primary key session_ID.

Can any1 help me work this out?

[pbaldy]

Sounds like you need to add session_ID to the criteria in the DCount.

[callylj]

Yer, but how do i add session_ID into the formula and use the formula i'm already using to add up attendance for each session:

=DCount("[Attendance]", "[tbl.member/session]", "[Attendance]=True")

The table with the attendance tick boxes is in tbl.member/session
But the session_ID main table is in tbl.session.
Is there anyway i can put them both in the same formula.