Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Database Design / April 2005

Tip: Looking for answers? Try searching our database.

Combining Time and Date

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Trial & Error - 18 Apr 2005 14:38 GMT
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 - 18 Apr 2005 15:05 GMT
Use m/d/yyyy h:nnAMPM (see help for other Format options)

Signature

Paul Overway
Logico Solutions
http://www.logico-solutions.com

>I have recieved advice to run date and time as 1 field, for many reasons.
>
[quoted text clipped - 11 lines]
> I am aware that access stamps each date with a time... my interest is in
> having this time visible.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.