Total of column with check boxes

[turbosdad]

I need to get a total of Active members that have a check mark in them, in one column
the total function shows all records, and the total in the records area will not show in reports

[Access_Blaster]

The SQL might look like this:

SELECT Abs(Sum([Yes/no field])) AS SumField
FROM YourTable;

[turbosdad]

I have some experence creating querys without expressions
do I put this expression in the query under the field i want to count?
how do I convert it from sql
do I need to creat a new field (expr1)

the field I want to count is named 'Active'

sorry to be such a newbie at this

this is the sql for the query, where do i place the new code?

SELECT [Membership Data].[National membership status active], [Membership Data].[Membership Record Number], [Membership Data].LastName, [Membership Data].FirstName
FROM [Membership Data]
WHERE ((([Membership Data].[National membership status active])=True) AND (([Membership Data].[Membership Record Number])<8000));

thanks for any help

[maximus]

I assume that u want to show the total No of Active members in the column of a query

well using DCount can be another option:
Create a calculative Field like Expr1 with this expression:

DCount("[MemberID]","tblMember","[ActiveMember]=True")

[turbosdad]

I wish to us the total in a report

when I get this query working I can modify it for use in other ( yes/No) fields