Error - template LAYOUT-DATA-WRAPPER not found

A configuration error was detected in the CGI script; the LAYOUT-DATA-WRAPPER template could not be found.

Error - template STYLE-SHEET not found

A configuration error was detected in the CGI script; the STYLE-SHEET template could not be found.

Error - template SUB-TOP-BANNER not found

A configuration error was detected in the CGI script; the SUB-TOP-BANNER template could not be found.

Subject:	Re: Help with data type in Access
From:	"Richard Quilhot, C.N.A." <[log in to unmask]>
Reply To:	PCSOFT - Personal Computer software discussion list <[log in to unmask]>
Date:	Thu, 16 Aug 2001 00:46:48 -0400
Content-Type:	text/plain
Parts/Attachments:	text/plain (22 lines)

In the Telco business duration of calls is stored as an integer with the
assumed format of:   MMMMSST.
Meaning we can record up to 9,999 minutes, 99 seconds (never goes past 59),
and the tenth of a second.
This could easily be changed to HHMM or whatever your degree of accuracy
needed.

Rick Quilhot
[log in to unmask]
-----Original Message-----

What data type should I use on an Access table to store the number of =
hours and minutes in one field. I tried using Date/Time, but it won't =
accept times longer than 24 hours.

TIA
Nicolas

              The NOSPIN Group is now offering Free PC Tech
                     support at our newest website:
                          http://freepctech.com

ATOM RSS1 RSS2

LISTSERV.ICORS.ORG