Continuous Form [TextBox] SQL Question

[Bill6868]

On my continuous form I have a field named [RSVP]. It is a yes/no check box which tells me if this individual has responded RSVP and will attend the event. In the form header I want to use a [TextBox] to count the number of yes responses. If I write =Count(*) it just gives me the total number of records on the continuous form. Is there something I can write that will give me the number of yes (-1) responses.

Any advice would be greatly appreciated. Thanks.

 

[dhookom]

Try:

=Sum(Abs([RSVP]))

Duane
Hook'D on Access
MS Access MVP

 

[Bill6868]

This worked great. Not sure what Abs means but it worked. dhookom - thank you, thank you, thank you!

 

[dhookom]

Click the Help button in Access or search the web for Abs().

Returns a value of the same type that is passed to it specifying the absolute value of a number.

The absolute value of a number is its unsigned magnitude. For example, ABS(-1) and ABS(1) both return 1.

I only wish my "abs" were so well defined ;-)

Duane
Hook'D on Access
MS Access MVP