Question Locked

Access 2003 Formula Question

0 helpful

5 replies

by skinner310 Apr 28, 2008 last reply Apr 29, 2008

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have a simple formula
total: [Field1]-[Field2]
if the total value is negative I would like value = zero. How do I do this? Stumped!

5 replies

Clarifications

=IIf([Field1]<[Field2], 0, [Field1]-[Field2])

Worked perfect!

Thank you!

Total: IIf([Field1]-[Field2]>0, [Field1]-[Field2], 0)

Thank you!

This discussion is closed to new replies.