Create Total Column in Query 1

[DTSjunkie]

This is my first post on these forums. I have a couple checkboxes in a MS access query. I want to summate the total number of "Yes" (Checked) items. Is there an easy way, like putting all the variables in the SUM() function in a new expression? Here is a screenshot of the query:

http://img264.imageshack.us/my.php?image=totalquery3nu.jpg

Any help is greatly appreciated.

Will

 

[PHV]

Something like this (SQL code) ?
SELECT [Subject ID], Abs(QBQpreCP+QDKSpreCP+QHFSpreCP+QSTPIpreCP+QSDEpreCP) AS NumberOfYes
FROM yourTable

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[DTSjunkie]

Thank you!! That worked perfectly