Look ahead in time field

[RickK]

How do I default (declare) a time field value to be a greater (future)value than the previous time field used in a record (twenty time fields in this record)?

The problem occurs when user's time passes through midnight (Field 1 at 8:00 PM and field 2 at 4:00 AM) This produces a numerical value in the negative range (-57,600 rather than 28,800), the calculation is looking back rather than ahead regardless of the AM/PM suffix or a 24 hour clock entry.

The current solution for one field (One_Time) is:

If(One_Time = 0,0,

If(Two_Time <= 0 and End_Time > 0, End_Time - One_Time,

If(Two_Time = 0 and End_Time = 0, Current_Time - One_Time,Two_Time - One_Time)))

Any suggestions appreciated Thx

[Chuck]

Try this:

code:

---

Case(

[RickK]

quote:

---

Originally posted by Chuck:

Try this:

code:

Case(

[RickK]

quote:

---

Originally posted by Chuck:

Try this:

code:

Case(