Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2009
    Posts
    7

    Unanswered: IBM DB2 and Access '97

    I am using IBM DB2 v7.2 on Server 2003 using Access '97 (has to be '97 due to the program that it runs with).
    I am in need of making the minutes (which look like such(12.9877)) to equal HH:MM:ss
    This is what I have come up with in the Reports field but still I am unable to get a correct result:
    Avg([FFF])&Format([00\:00\:00])
    Also the FFF is pointing to the Queries and is set to: FFF: DateDiff("n",[TEST_PERFORMED],[TEST_ACQUIRED])
    I have tried many diff option in rewriting this to work. Any ideas are welcome...
    Thanks
    Sorry about the first rev of this question...
    Last edited by Krvin; 07-21-09 at 13:30.

  2. #2
    Join Date
    Dec 2008
    Posts
    76
    Can you restate your question, I can't figure out what it is you are asking.
    RD

Posting Permissions

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