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))
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Summing or diferent sites within a day 1
Display lapsed time in hours and minutes 3
Calculating total hours 2
Time Keeping Spreadsheet (Need not to Exceed Formula & subtracting 1
IIf statement in a report 2
Conditional Formatting Problem and #Name? Error 1
too complex for me! 8
Dates 1

Back
Top