Adding time to a time field

[davesmith202]

I have a time field MyTime where I want to add 45 minutes. I want to then store the result in a memo field.

I've tried this:

MyMemoField=[MyTime]+45

It doesn't work!!

Any ideas?

Thanks,

Dave

 

[Alansidman]

Look at this discussion of DateAdd function

http://www.techonthenet.com/access/functions/date/dateadd.php

Alan

 

[davesmith202]

That was really useful. Thanks.

 

[gemma-the-husky]

date/times are represented by a whole number of days, and a fraction of a full day.

so, adding +45 actually adds 45 days.

45 minutes is actually 45/60 (minutes) of 1/24 (hours) of a day, or 1/32 of a full day (hope that makes sense) which is approximately 0.031 - so that is what you needed to add.

the dateadd function does all these calculations for you in an easier way.