Should I use a form for report? I Need to convert time first.

[CTOROCK]

I have a query that gives time in seconds, now, I want to display that time in the conventional XX:XX, short time. now I do this with:
MyTime = Format(DateAdd("s", SngSeconds, "00:00:00&quot, "Hh:Nn:Ss&quot

It doesn't seem that I could do this in a report because if i do that to the control boxes, It only does it for one record then freezes. So I think that I can use a form and use the Time interval set to three seconds to run down each record and convert it for me. But I'm going to need a print preview and the timer doesn't work there. should i do it in form view then after, change to print preview? How do I do this? Is there a better way? "The greatest risk, is not taking one."

 

[Namsha]

You can have one format in the form and as long as you have the whole format in the table or linking query you should be able to format in the report. In the controls properties set the format that you want in the report. That should do it. Much easier than your way.

Nina I can expect anything and everything of myself;
But can only accept or reject what you have to offer!

 

[CTOROCK]

I don't understand exactly what you mean, can you explain a little more?
Thanks!
"The greatest risk, is not taking one."