Question about Times in Access Table

[Littlma]

Good Afternoon All

I have a question with regards to a Database that I am building as a project. I am a therapist and I built a Client database that with apointment table so it can basically record the history of my clients appointments. Here's the fundametals of what I want my appointment table to do:

I have a field called TimeNextAppointment - this is formatted to short time and I have done a lookup to a Time_tbl that has from 00:00hrs to 23:30hrs (my appointments go in half hour increaments). Also in Appointment_tbl I have a field called DurationSession, this looksup data in Duration_tbl, and is gives the options from 30 to 240 minutes slots. So what I want to achieve is when I select the appointment time, say 14:00hrs and the duration of the session is say 30 mintues in the FinishTime field I would like it to auto populate with 14:30hr.

Can this be done?? and how can I achieve this??.

I have searched everywhere on web and in books but have not found a solution that helps me.



Thank you in advance for assistance given.

[rpeare]

If you are always storing your duration in minutes you could use the dateadd function

Dateadd("n", [TimeField])

for the dateadd function n means minutes, and timefield would be your appointment starting time.