Would someone help me with adding the time from songs on a CD? If 1 song is
5:45 & another is 5:45, that = 11 minutes & 30 seconds, yet I don't get that.
Thanks
What datatype are you using? What DO you get, and how are you doing
the addition?
Access Date/Time fields aren't ideal for storing durations: a
Date/Time value of 5:45 actually means 45 minutes after 5 AM on
December 30, 1899, not "five minutes and forty-five seconds". For
storing song durations, you may be better off using a Long Integer
SongDuration field, storing 345 seconds (for 5:45). You can display
this value using an expression like
[SongDuration] \ 60 & Format([SongDuration] MOD 60, ":00")
to display as 5:45; this will work for sums just as well. For data
entry you can use three textboxes - two unbound for minutes and
seconds, one bound to the SongDuration field. Use code in the
textboxes' AfterUpdate event to populate the bound control.
John W. Vinson[MVP]
