add time to a field - MINUTES

[Guest]

the DateAdd function works well for adding hours and days, but how would I
add, say 10 minutes to a time based data field?

 

[fredg]

the DateAdd function works well for adding hours and days, but how would I
add, say 10 minutes to a time based data field?

NewTimeateAdd("n",10,[DateTimeField])

 

[Guest]

thanks a million Fred...I'll try it....wonder why nothing the Help files in
Access about the use of "n"...perhaps I just missed it or it was too obvious

eck

the DateAdd function works well for adding hours and days, but how would I
add, say 10 minutes to a time based data field?

NewTimeateAdd("n",10,[DateTimeField])

 

[fredg]

thanks a million Fred...I'll try it....wonder why nothing the Help files in
Access about the use of "n"...perhaps I just missed it or it was too obvious

eck

the DateAdd function works well for adding hours and days, but how would I
add, say 10 minutes to a time based data field?

NewTimeateAdd("n",10,[DateTimeField])

Did you look in VBA help?
........
The interval argument has these settings:

Setting Description
yyyy Year
q Quarter
m Month
y Day of year
d Day
w Weekday
ww Week
h Hour
n Minute
s Second