Combining Time and Date

[Trial & Error]

I have recieved advice to run date and time as 1 field, for many reasons.

How do I go about formatting this field so that the date and time are both
visible

the DB will be used to book lesson times... as such, both the day and time
of day are very important.
Both need to be entered, and lessons per day and per hour must both be
easily retrieved & displayed.

The formats provided under date/time easily display either short / long date
formats or time formats... but not both.
I am aware that access stamps each date with a time... my interest is in
having this time visible.

 

[Paul Overway]

Use m/d/yyyy h:nnAMPM (see help for other Format options)