G
Guest
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.
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.