B
Bunky
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
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