Adding Time

Brendan Bartley · January 17th, 2006, 06:04 AM

Hi all Again

I have a query that I need to be able to add the time which is formatted in hours minutes and seconds

Thanks
Brendan

Brendan Bartley

anukagni · January 17th, 2006, 07:13 AM

Hi,

Do u have Time in the Table, that u used for the Query., If so u can use directly or u have to add in the table that u using for the query .,GO to table design view in the data type format into long time

try like that or sent the comment,

Bye,
Pap

AccessMaster · January 21st, 2006, 03:36 AM

Check this out:

Time, adding and subtracting time and timesheets
at
http://www.mvps.org/access/datetime/date0009.htm

Boyd
"Hi Tech Coach"
Access Based Accounting/Business Solutions developer.
http://www.officeprogramming.com