Anyone know how to do this in access?

Smiley Man · 16 May 2007 at 11:30

hi guys

i need to have a field type as minutes and seconds, basically MM:SS, but it will only let me do HH:MM:SS, so when i put a song in thats 6 minutes 20 seconds long it assumes its 6 hours 20 minutes long

this is the last thing i have to do before i can get this damn project handed in, anyone got any ideas of how to sort it?

Jaffa_Cake · 16 May 2007 at 11:58

Can you not use 00:06:20?

Smiley Man · 16 May 2007 at 12:48

i could, but it would be much easier for the user if they didnt have to put 00 for the hour, im sure theres a fairly basic way around it?

Eriedor · 16 May 2007 at 12:50

time = FormatDateTime(Time,"mm:ss")

Something along those lines, been awhile since I did vb6/vba

Smiley Man · 16 May 2007 at 13:58

Eriedor said:
time = FormatDateTime(Time,"mm:ss")

Something along those lines, been awhile since I did vb6/vba

wereabouts would i put that?

marc_howarth · 16 May 2007 at 15:47

this link may help

http://www.techonthenet.com/access/tables/format_date.php

basically in the format section just type nn:ss i would guess

WolfR1der · 16 May 2007 at 20:46

marc_howarth said:
this link may help

http://www.techonthenet.com/access/tables/format_date.php

basically in the format section just type nn:ss i would guess

Had a go at this too, but that doesn't seem to work, looks like Access just can't handle minutes and seconds without hours too.

If you use short time, does that not produce the same results as minutes and seconds? It's output as 06.20 either way. Add an appropriate input mask and that's all that will save.

Unless you're doing something that requires the data type to be set properly...
If it's for display/report purposes, I can't see it making a difference. If you have to do documentation just explain the difficulty. Or blag it and pretend NN:SS worked...*(Not recommended)

Smiley Man · 16 May 2007 at 23:20

WolfR1der said:
Had a go at this too, but that doesn't seem to work, looks like Access just can't handle minutes and seconds without hours too.

If you use short time, does that not produce the same results as minutes and seconds? It's output as 06.20 either way. Add an appropriate input mask and that's all that will save.

Unless you're doing something that requires the data type to be set properly...
If it's for display/report purposes, I can't see it making a difference. If you have to do documentation just explain the difficulty. Or blag it and pretend NN:SS worked...*(Not recommended)

no calculations or anything are going to be done on it, so having hours there too isnt the end of the world, just it looks messy

i will mess around with an input mask