Format currency as 8 digit number in query

[ascaife]

Hi all,

Hope this isn't too silly a question.

I have a currency field in my database that needs to be formatted in a specific manner for output to a 3rd party system.

The number needs to include 8 digits with trailing or leading zeroes.

Eg.
$585.00 = 00058500
$585.45 = 00058545

If anyone could help me out that would be awesome.

Thanks,

Andrew

 

[Galaxiom]

Format([fieldname]*100, "00000000")

Note however the result is a string rather than a number.

 

[ascaife]

Wow that was fast.

Worked a treat, and string is fine as it outputs as text.

Thank you so much