Inline IF statement

[Guest_imported]

Hello,

I have a query that is to sum up a time from a second query.

the query uses the variable 'total' as the column to sum.

I need help with a iif statement to check for negative times, if they are negative then I need to mulitple it by -1 to get a positive result.

Any help would be welcomed

Gary

 

[DougP]

=IIF(yourfield < 0, yourfield * -1, yourfield)

so it works like this

if your field is less than zero then
take yourfield times negeative 1
else just yourfield left alone

the True part is left after the first comma
and the False part is after the second comma

;-) DougP, MCP

Visit my WEB site

http://www.barcodeone.com

to see how Bar-codes can help you be more productive