Addition of minutes to a time value????

[Breisi]

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

 

[Kensan]

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

 

[Breisi]

Thanks, I'm new at this, that was exactly the function I was looking for.
Breisi