I have a form that contains several fields including a start time and a stop time. The two time fields are date/time data types. I added a non-bound field to the form that holds the calculated time, e.g., timein-1-timeout. The footer of the form has a non-bound field that sums the calculated time field. However, when the form is run, the footer field shows #error.
I've tried converting the calculated field to a decimal and then converting it back to a short time in the footer field, but still get an error.
I'm thinking that the sum function in the footer field cannot be used on the non-bound calculated time field on the form. Just so you know, the form is run as a datasheet, but for testing, I'm running it in form view.
Any help on this would be appreciated.
Thanks.
I've tried converting the calculated field to a decimal and then converting it back to a short time in the footer field, but still get an error.
I'm thinking that the sum function in the footer field cannot be used on the non-bound calculated time field on the form. Just so you know, the form is run as a datasheet, but for testing, I'm running it in form view.
Any help on this would be appreciated.
Thanks.