Microsoft access time manipulations

[inewham]

Is it possible to add a numeric value to a time field and have the result displayed as a time within Microsoft access querys or reports.
thanks Ian

 

[WildHare]

Yes. Use the DATEADD function with the appropriate modifiers so it knows you're adding minutes or hours or seconds:

DateADD("d", 1, date) = one DAY from today
DateADD("n", 1, now) = one minute from now

N = minutes
S = seconds
H = hours
D = days
M = months

Jim There are two ways to argue with a woman - neither one works.
Another free Access forum:

http://www.forumco.com/jmhare

More Access stuff at

http://www.jmhare.com/wildhare2.htm