Is there a SumIF function in Access? I have to SUM a duration of time, but only if a logical Yes/No check box is TRUE. I am working with the expression builder and a Text Box. Thanks for the help.
Forgive me...I'm a beginner programmer with expert expectations.
Hi - You need to nest your IF and SUM functions, like so: IF(y/n field=y,SUM(value1,value2)null) This means if y/n criteria is true, the sum of value1 and value2 appears, if not then a null (blank) value appears. Eddie
Tee GEE wrote:> Is there a SumIF function in Access? I have to SUM a duration of time,> but only if a logical Yes/No check box is TRUE. I am working with the> expression builder and a Text Box. Thanks for the help.>
Forgive me...I'm a beginner programmer with expert expectations.>
This is going to Sum the data. If you want to sum the duration such as from 8am to 4pm then you might look at the TimeValue function.
Returns one of two parts, depending on the evaluation of an expression.
Syntax
IIf(expr, truepart, falsepart)
The IIf function syntax has these named arguments:
Part Description expr Required. Expression you want to evaluate. truepart Required. Value or expression returned if expr is True. falsepart Required. Value or expression returned if expr is False.
Remarks
IIf always evaluates both truepart and falsepart, even though it returns only one of them. Because of this, you should watch for undesirable side effects. For example, if evaluating falsepart results in a division by zero error, an error occurs even if expr is True.
Tee GEE wrote:> Is there a SumIF function in Access? I have to SUM a duration of time,> but only if a logical Yes/No check box is TRUE. I am working with the> expression builder and a Text Box. Thanks for the help.>
Forgive me...I'm a beginner programmer with expert expectations.>
=Sum(IIf([Your logical yes/no field]=True,[Your duration of time field],0))
This is going to Sum the data. If you want to sum the duration such as from 8am to 4pm then you might look at the TimeValue function.
Returns one of two parts, depending on the evaluation of an expression.
Syntax
IIf(expr, truepart, falsepart)
The IIf function syntax has these named arguments:
Part Description expr Required. Expression you want to evaluate. truepart Required. Value or expression returned if expr is True. falsepart Required. Value or expression returned if expr is False.
Remarks
IIf always evaluates both truepart and falsepart, even though it returns only one of them. Because of this, you should watch for undesirable side effects. For example, if evaluating falsepart results in a division by zero error, an error occurs even if expr is True.
Tee GEE wrote:> Is there a SumIF function in Access? I have to SUM a duration of time,> but only if a logical Yes/No check box is TRUE. I am working with the> expression builder and a Text Box. Thanks for the help.>
Forgive me...I'm a beginner programmer with expert expectations.>
Tee GEE wrote:> Is there a SumIF function in Access? I have to SUM a duration of time,> but only if a logical Yes/No check box is TRUE. I am working with the> expression builder and a Text Box. Thanks for the help.>
Forgive me...I'm a beginner programmer with expert expectations.>
If you would like to report an abuse of our service, such as a spam message, please . Если Вы хотите пожаловаться на содержимое этой страницы, пожалуйста .
