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

[Mseme]

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?

 

[Brian]

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)