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...

Can you restate your question, I can't figure out what it is you are asking.