value not to exceed

  • Thread starter Thread starter DFDGirl
  • Start date Start date
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
 
A guess--

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

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