How do I insert a colon so a string of numbers is recogized as a t

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a database that contains a time field where all of the times should be
shown in the HH:MM:SS (hours, minutes, seconds) format. However, all of the
times are missing the second colon, so they appear as HH:MMSS and are
accordingly not recogized as times. I need to insert a colon before the
seconds. Is there something I can do to have Access 2000 insert a colon two
digits from the end of each string in the cell?
 
Mseme said:
I have a database that contains a time field where all of the times should be
shown in the HH:MM:SS (hours, minutes, seconds) format. However, all of the
times are missing the second colon, so they appear as HH:MMSS and are
accordingly not recogized as times. I need to insert a colon before the
seconds. Is there something I can do to have Access 2000 insert a colon two
digits from the end of each string in the cell?

New query, click the SQL button, paste this in and run it:

UPDATE some_table SET some_field = Left(some_field,5) & ":" &
Right(some_field,2)
 
Back
Top