Convert qry output to string... (integer to string)

[Steff_DK]

I have a query like:

.[Hrs] & ":" &

.[Mins] that produces an output like "12:31"

However if

.[Mins] is 1 then the output will be "12:1"

I tried Format(

.[Mins],00) but since it is still an integer Access changes my query to read Format(

.[Mins], 0 )...

How do I convert it to a string and then perform the 00 format???

 

[pbaldy]

Format(

.[Mins],"00")

 

[Steff_DK]

And now it works...

Stupid quotation marks!!!