Subject: Adding Time
Posted By: Brendan Bartley Post Date: 1/17/2006 5:04:13 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
Reply By: anukagni Reply Date: 1/17/2006 6:13:12 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
Reply By: AccessMaster Reply Date: 1/21/2006 2:36:19 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

Go to topic 38731

Return to index page 389
Return to index page 388
Return to index page 387
Return to index page 386
Return to index page 385
Return to index page 384
Return to index page 383
Return to index page 382
Return to index page 381
Return to index page 380