In keeping a database of my CD collection, I find myself very frustrated that Microsoft Access doesn't have a built-in time function. I'm not talking about time as in on a clock. It has that. I'm talking about elapsed time so that I can have that as a field in the table of tracks. Instead I have to fake it with two fields, one for minutes and one for seconds. So a tack that is, say, three minutes and 29 seconds long has 3 in the minutes field and 29 in the seconds field. An alternative would be to have just seconds, in which case the same track would have 209. But what I'd prefer is one field in which I input 3:29.
Anyone know a workaround?