You can use it on the Field row in a query, prefixed with a name you want for the field and a colon.
John Viescas, author "Building Microsoft Access Applications" "Microsoft Office Access 2003 Inside Out" "Running Microsoft Access 2000" "SQL Queries for Mere Mortals" http://www.viescas.com/ -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Mike Bisson Sent: Sunday, January 29, 2006 8:27 AM To: [email protected] Subject: RE: [ms_access] Converting a number to hh:mm:ss format Thanks John - Can I just put this in the grid in my query, or do I need to put it someplace else? -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of John Viescas Sent: Sunday, January 29, 2006 9:16 AM To: [email protected] Subject: RE: [ms_access] Converting a number to hh:mm:ss format Mike- Format(Int([Seconds]/3600), "00") & ":" & Format(Int(([Seconds] Mod 3600) /60), "00") & ":" & Format([Seconds] Mod 60, "00") John Viescas, author "Building Microsoft Access Applications" "Microsoft Office Access 2003 Inside Out" "Running Microsoft Access 2000" "SQL Queries for Mere Mortals" http://www.viescas.com/ -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Mike Bisson Sent: Saturday, January 28, 2006 11:12 PM To: [email protected] Subject: [ms_access] Converting a number to hh:mm:ss format Hi all, I have a field in my table that stores a numeric value for total number of seconds. I would like to convert this to hh:mm:ss format when running my reports. Can someone tell me what the string for the conversion would be? As always - thanks in advance for any help :) ================================== Mike Bisson Manager of IT & Logistics Carthuplas, Inc. V: 207-985-4972 x658 F: 207-985-2105 [EMAIL PROTECTED] http://www.carthuplas.com Yahoo! Groups Links Yahoo! Groups Links Yahoo! Groups Links Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
