Hi;
I use an Access 365 database to catalog my music library. When I created the db, I mistakenly used a date/time field for the track duration, then converted it to a text field. Doing that, I ended up with the format hh:nn:ss (where nn is minutes). When I entered the times for each track, I used only the hh:nn but not the ss, so all the records show 00 for seconds.
After entering quite a bit of data, I changed the input mask for the time field to 00:00.
I am looking for a method - probably an update query - to change all the times to use only hh:nn. I thought since it's a text field, I should be able to use the len function to truncate the field to 5 characters (from 8 characters), but it's been a while since I've done any 'coding' for Access.
Thanks for your help
Ultrarunner