Extracting totals from an Option Group

[rkcksk]

I am a new developer in the middle of my first application, so please excuse the basic questions.

I have created a form using several option groups (Bill Type Processed, Bill Type Corrected, Bill Resolution Method) to save on database fields. They work great. But, now I need to be able to sum how many choice # 1's, choice # 2's, choice # 3's I have each day on a report. I am having problems writing the expression (not as easy as just saying = sum (fieldname)).

Thank You.

 

[hjgoldstein]

Try this SQL in a query.

SELECT Count(TblTableName.Option) AS CountOfOption
FROM TblTableName
WHERE (((TblTableName.Option)="1&quot);
UNION
SELECT Count(TblTableName.Option) AS CountOfOption
FROM TblTableName
WHERE (((TblTableName.Option)="2&quot);
SELECT Count(TblTableName.Option) AS CountOfOption
FROM TblTableName
WHERE (((TblTableName.Option)="3&quot);

The values of the option groups are 1 for the first option, 2 for the second etc.

Hope this helps.