Summing up minutes and seconds

[martijnvm]

Hello guys,

When posting a new topic in a forum it's common that the author is experiencing a problem. Well this time is no exception to that rule.

I'm trying to manage tracklists for users which contain, obvious, tracks.

As we all know, a audio cd can normally contain 74 minutes.

I would like to show the users the available time left between the length off the selected tracks and max 74 minutes.

That's why I need to know who to sum up the lengths of the selected tracks and then extract them from the 74 minutes.
I would also like to know which date format I should use in my Access database.

Maybe someone has a solution to this, because I sure don't.

Tnx in advance,

Martijn van Mechelen

 

[jlgdeveloper]

If you are trying to add time, ie minutes, seconds, hours, days etc then use the dateAdd functions or dateDiff functions. Jonathan Galpin

http://www.keen.com/categories/categorylist_expand.asp?sid=5215353&gid=0&pmode=0

 

[martijnvm]

Let me explain further,

I'm not really trying to add time to the database, because the lenghts of the tracks are already specified in the table Track.

The table Cds contains the CdIds, which are related to a UserId, and the TrackIds of the selected tracks.

So I want to sum up the length of the selected tracks and then determine how much time is left of the original 74 minutes available.

Maybe you can help me out with this?

Greetings,

Martijn

 

[mgriffith]

select (74 - (select sum(a.tracklen) from Track a WHERE a.cdId=4 and (a.trackid=5 or a.trackid=8 or a.trackid=10))

maybe something like this??

 

[martijnvm]

I think that that wouldn't work because the tracklengths are stored in the database like 00:03:36

Maybe I'm wrong, but i'll will give it a try

Tnx,

Martijn

 

[jlgdeveloper]

Select all the tracks, one by one, use the dateadd fuction to add each time to a variable, subtract from 74. Keep the answer in minutes. Jonathan Galpin

http://www.keen.com/categories/categorylist_expand.asp?sid=5215353&gid=0&pmode=0

 

[martijnvm]

Well,

If I knew how I could do that, I would do it.

How do I select the tracks one by one?

Do I have to put them in a array or something? if yes: how?

Greetings,

Martijn