B
Box666
I have 4 date boxes on a form, date boxes 1-3 are completed by the
operator, but I want date box4 to be the maximum of boxs 1-3 (but only
after all 3 boxes have been completed)
I have been able to do nothing until the 3 date boxes are completed,
but I cannot get it to choose the max date)
=IIf(IsNull([date1] And [date2] And [date3])," ",Max([date1] or [date2]
or [date3]))
Any help gratefully received
Bob
operator, but I want date box4 to be the maximum of boxs 1-3 (but only
after all 3 boxes have been completed)
I have been able to do nothing until the 3 date boxes are completed,
but I cannot get it to choose the max date)
=IIf(IsNull([date1] And [date2] And [date3])," ",Max([date1] or [date2]
or [date3]))
Any help gratefully received
Bob