Formatting

[Guest]

I have a Date/Time field that I am converting to a text field. My expression
in the query is
Expr4: IIf(IsNull([Avg Talk Time]),"00:00:00",Format([Avg Talk Time],'00\:')
& Format([Minutes],"00") & Format(":") & Format([Seconds],"00"))

This works fine but if the Minutes are greater than 11, it automatically
adds 1 to what would be the hours. The minutes are showing fine and there
won't be anything in the hours value at present. How can I just put zeros in
the two positions prior to the minutes?

Thank you

 

[Guest]

Never Mind - I just figured it out.