Access Time card ?

D

Dennis

I have a table which includes fields

Timein
Timeout
Total Hours

How do you get the sum of all records for Total hours.

Thanks
Dennis
 
M

M.L. Sco Scofield

Unfortunately, calculating times like this is a tad tricky. There is
information and functions for doing this in the article at
http://support.microsoft.com/default.aspx?scid=kb;en-us;210604.

Gook luck.

Sco

M.L. "Sco" Scofield, Microsoft Access MVP, MCSD, MCP, MSS, A+
Denver Area Access Users Group Communications Director www.DAAUG.org
MS Colorado Events Administrator www.MSColoradoEvents.com
Useful Metric Conversion #18 of 19: 8 nickels = 2 paradigms (My personal
favorite)
Miscellaneous Access and VB "stuff" at www.ScoBiz.com
 
Top