Combine value of 2 seperate fields in a third

[zebra]

Hi,
My system reads two fields, one with fromtime the other thrutime. These fields are in the format dd/mm/yyyy hh.mm.ss. But to make the system more user friendly on the input form I want to have a date selection box, and start and end time boxes. If I do this can I then code fromtime and thrutime to be the combination of the date and start/end time? Should I be looking at queries? I still don't get what they are.

Not sure if that's explained too well, sorry.
Thanks,
Zebra

 

[Fifty2One]

I use one of Allen Browne's very cleaver utilities for a pop up calendar where the end user can click on a calendar button and the current calendar pops up, they select the date and it will insert it into the form.
http://allenbrowne.com/ser-51.html
I would suggest just keeping the date stamps in your database and do the calculations on dates as needed on the fly if you need to display durations or time lapses

 

[zebra]

Thanks, the trouble is the user has to enter the times too. I don't know, has anyone written a popup calendar with time entry too that then feeds back to a single cell?