Here's something I thought I'd know how to do ...

I have an Appointments table and want to add a duration (integer
representing hours) to a start time (Date/Time field, "Short Time" format)
to give a finish time. I want to do this in a query but if I do
[StartTime]+[Duration] I get a date returned. I've tried using the Format
function to no avail.

What forehead slappingly obvious trick am I missing?

Thanks.

Keith.

"Keith Wilby" <here (AT) there (DOT) com> wrote

[Duration]/24 seems to work but there must be a more elegant solution ...

Keith, try:
DateAdd("h", [Duration], [AppointmentTime])

Since Duration is an integer in hours, that should do it.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Keith Wilby" <here (AT) there (DOT) com> wrote

"Allen Browne" <AllenBrowne (AT) SeeSig (DOT) Invalid> wrote

Thanks Allen.