George- =Format([MyTime], "nn:ss")
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 George Oro Sent: Sunday, December 18, 2005 4:47 AM To: YG Access Subject: [ms_access] TIME FORMAT Hi Group, How can I format this time (12:30:00) that will appear only the minutes and seconds (30:00)? What format I have now is (00:30:00), basically I want to remove the two leading zero but still consider as time because I'm using this as a counter 30mnts to zero. Any tips would be greatly appreciated. TIA, George [Non-text portions of this message have been removed] Yahoo! Groups Links ------------------------ Yahoo! Groups Sponsor --------------------~--> Most low income homes are not online. Make a difference this holiday season! http://us.click.yahoo.com/5UeCyC/BWHMAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> 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/
