value not to exceed

D

DFDGirl

I have a sum of vacation hours on a report. I do not want the "total"
number of hours that I track to go over 240. How can I do this?

Thank you
 
J

John Spencer

A guess--

Use a formula something like the following in a control that is not named Vacation

=IIF (Sum(Vacation)>240,240,Sum(Vacation))
 
Top