WorkDate / TrainTime
03/06/00
03/07/00 4:00
03/08/00
03/09/00
What is the syntax to select the "4:00" as the total training time for the days 3/6 - 3/9? (assumes only one value in list, else blank)
Sele iif(!empty(traintime),traintime,space(4)) as TotTrain
arbitrarily grabs the first record, evaluates the iif and likely stores the wrong value to TotTrain. This field is character, so sum() is not available on this field without a lot of string manipulation.
Is there an easy way to do this?