Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2006
    Posts
    2

    Unanswered: Summing durations

    Hi, first time here, hope this doesn't sound too dumb. I'm trying to adjust a db that someone else has set up ... anyway,

    I want to sum durations (of video). The durations in the table are numbers formatted as "00.00". They are all in minutes and seconds.

    When I sum them (either in a report or a query) I get different results depending on the format I have entered (either 00.00 or nn:ss). No results are correct!

    I'm not sure if I'm putting formats in the wrong spot or the wrong way. I've tried putting everything everywhere & now I'm VERY confused.

    Obviously there's something I'm completely misunderstanding ...

  2. #2
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    What do you envision your end result looking like? Hours:Minuteseconds?
    Back to Access ... ADO is not the way to go for speed ...

  3. #3
    Join Date
    Sep 2006
    Posts
    2
    The total should always appear as minutes and seconds.

  4. #4
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,482
    Provided Answers: 11
    mmmmmmmmmmm
    that a good one

    as minutes and seconds. is not 100 base suming then up is going to be a bit tricky

    ie sec only count up to 60 then a 1min clicks over that what you need to do
    get the computer to count/sum in 60th

    I'll look for some old code I wrote to fix this I wrote a few PC's ago
    Last edited by myle; 09-13-06 at 00:15.
    hope this help

    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.
    DONT WORRY ABOUT THOSE WHO TALK BEHIND YOUR BACK
    THEY'RE BEHIND YOU FOR A REASON

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •