Hi,
I've been trying to calculate elapsedtime between two fields in a database.
I have field1 and field2 in short time format and the easy way "field2-field1" gives me the correct elapsed time in the short time format in a new field in my form.
But for some records I don't have the data to fill in field1 and field2, so I created field3 in my table where I can enter the time myself in the short time format.
Now I want a new column in my form with a function that gives me "field2-field1" OR field3 if field1 & field2 are empty.
I don't manage to do this. Can anyone give me a sollution how to program my function (options, declaration, function, ...).
anyone?
thx
I've been trying to calculate elapsedtime between two fields in a database.
I have field1 and field2 in short time format and the easy way "field2-field1" gives me the correct elapsed time in the short time format in a new field in my form.
But for some records I don't have the data to fill in field1 and field2, so I created field3 in my table where I can enter the time myself in the short time format.
Now I want a new column in my form with a function that gives me "field2-field1" OR field3 if field1 & field2 are empty.
I don't manage to do this. Can anyone give me a sollution how to program my function (options, declaration, function, ...).
anyone?
thx