IIF Function

[Denver]

Hello,

I have a checkbox in this Field "Red Line" and i have this calculations in
my query that counts number of True

Red Line: Abs(Sum(IIf([Rd Line]=0,1,0))-([Total Records]))

i want to count number of False, how can i modify this formula? iam using
access 2003.

thanks for any help

 

[Douglas J. Steele]

Sum(IIf([Rd Line]=0, 1, 0) actually gives you the number of False. From
that, you're subtracting the total number of records and then taking the
absolute value to get True.

I think you'll find that using Sum(IIf([Rd Line] = 0, 0, 1) will give you
the number of True.

 

[Douglas J. Steele]

Ooops. I see I left off the closing parentheses.

Sum(IIf([Rd Line]=0, 1, 0)) should give you the count of False, Sum(IIf([Rd
Line]=0, 0, 1)) should give you the count of True.

Sorry about that.


--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

Sum(IIf([Rd Line]=0, 1, 0) actually gives you the number of False. From
that, you're subtracting the total number of records and then taking the
absolute value to get True.

I think you'll find that using Sum(IIf([Rd Line] = 0, 0, 1) will give you
the number of True.


--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

Hello,

I have a checkbox in this Field "Red Line" and i have this calculations
in
my query that counts number of True

Red Line: Abs(Sum(IIf([Rd Line]=0,1,0))-([Total Records]))

i want to count number of False, how can i modify this formula? iam using
access 2003.

thanks for any help

 

[Denver]

Thank you very much Douglas J.Steele.

Ooops. I see I left off the closing parentheses.

Sum(IIf([Rd Line]=0, 1, 0)) should give you the count of False, Sum(IIf([Rd
Line]=0, 0, 1)) should give you the count of True.

Sorry about that.


--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

Sum(IIf([Rd Line]=0, 1, 0) actually gives you the number of False. From
that, you're subtracting the total number of records and then taking the
absolute value to get True.

I think you'll find that using Sum(IIf([Rd Line] = 0, 0, 1) will give you
the number of True.


--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

Hello,

I have a checkbox in this Field "Red Line" and i have this calculations
in
my query that counts number of True

Red Line: Abs(Sum(IIf([Rd Line]=0,1,0))-([Total Records]))

i want to count number of False, how can i modify this formula? iam using
access 2003.

thanks for any help