Issues with formatting a HEX field

K

kolsby

I have a hex field that i need formatted like the following "00 40 C0
00 00 00" I would like the field to display just like this which is
possible with an autonumer using the format function but i can't seem
to get it to work in a query with using the hex function.

Please help if you can!

thanks,
KO
 
Top