how to break the bounds of 59 in date/time data type
- From: "x" <cupidisdangerous@xxxxxxxxxxx>
- Date: 16 Feb 2006 10:58:52 -0800
hi
i am a pilot by profession. i want to create a database of my logbook
using ms access 2002. i am facing a problem regarding the format of
time field. when i select "Data/Time" data type for my time field then
this format gives the liberty to record times uptill a figure of 59 in
different sub-formats, whereas i want the format to be able to record
the times like 80:35 or 1:10 or 1138:00. which means that i have these
many hours on a specific aircraft. i also want to carryout sum
operation on these timings. i have found out that i can use "[hh]:mm"
format in ms excel 2002 to suite my requirements but it doesn't work in
access.
i am a very basic user of access or for that matter any database.
please consider this while replying my question. i have no background
of vb code which means that i will only be able to work the things out
which are not very advanced (point and shoot mouse user).
Thanx in advance and please be eleborate in your reply.
bye and tc
.
- Follow-Ups:
- Re: how to break the bounds of 59 in date/time data type
- From: Tim Marshall
- Re: how to break the bounds of 59 in date/time data type
- Prev by Date: Re: Filename or path difficulty in a macro
- Next by Date: Running Metrics off of tracking DB
- Previous by thread: how do u open a specific ms word file??
- Next by thread: Re: how to break the bounds of 59 in date/time data type
- Index(es):
Relevant Pages
|
