Calculate end time. (1 Viewer)

[es2021]

I am doing an A-Level IT project within MS Access for a spa. I would like the end time field to be automatically calculated when I put in a start time, I have a time duration field for each treatment. I'd imagine I would need to have a calculated field for the end time which adds treatment duration onto treatment start time giving me the end time. I'm just not sure how I would write such a calculation. Thanks.

 

[bob fitz]

I am doing an A-Level IT project within MS Access for a spa. I would like the end time field to be automatically calculated when I put in a start time, I have a time duration field for each treatment. I'd imagine I would need to have a calculated field for the end time which adds treatment duration onto treatment start time giving me the end time. I'm just not sure how I would write such a calculation. Thanks.

Take a look at the dateadd() function. Use it to create a calculated field in a query which can then be used as the record source for a form. Do not keep the calculation in a table field.

 

[theDBguy]

Hi. Welcome to AWF!

I agree, don't store the calculated values and use DateAdd() to calculate them.

 

[Pat Hartman]

Normally, I would agree that you shouldn't store a calculated value but this is an estimate, not a final result and it might be needed for scheduling. See if the calculation in the query works for you before you try to store the value.