Concantenate Formats

[ECEK]

I have two columns hours and minutes in my table and a subsequent Query1.

I have formatted them in Query1 to appear as a two digit number (as a 24 hour clock) however when I concatenate them in Query2 as so..

Hours:[h]&":"&[m]

the results appear as one digits (where one digit was entered)
eg

14:1 as opposed to 14:01
2:25 as opposed to 02:25

I have tried to format the concatenated field "Hours" in the query but to no avail. eg 00:00

I have tried to Cstr([Field1]) in Query1 but that brings up errors.

How do I maintain the format that I have set in Query1?

 

[pr2-eugin]

If you had followed my code in your previous thread, this could have come easily for you.

Hours: Format([h], "00") & ":" & Format([m], "00")

 

[ECEK]

Im gettingthere Eugine. Your'e a star !!!

 

[pr2-eugin]

You're welcome !