Hello, I'm having difficulties finding a way of adding say 15 minutes to a time value specified in a form's field, so as to store this new updated value in another field in the same table.

That is, I have a StartTime and a SessionLength in the form and table and from these I need to calculate the EndTime to store in the table? HELP...

Thanks in advance http://www.access-programmers.co.uk/ubb/smile.gif

Hi Breisi

The following code should work

[EndDate] = DateAdd("n", [SessionLength], [StartTime])

Have a look at the DateAdd function in Access Help.

Hope this Helps

kensan

Thanks, I'm new at this, that was exactly the function I was looking for.
Breisi http://www.access-programmers.co.uk/ubb/smile.gif