dec2hex

[Donna]

Is there a way to convert decimal to hex in an access
query?


dec (24709558019) needs to be hex(f791d803)

The decimal field exists in my table and I need to create
the hex field in the same table.

Thank you for you help

 

[Allen Browne]

There is a Hex() function that will display a number as hexadecimal, but I
cannot imagine a scenario where you would want to store it both ways in the
table.

 

[Donna]

I found it. Only need to use Hex.
if esn is 10 digits Hex(esn,3) & hex(esn,7)

 

[Donna]

Thank you.

I'm not actually storing it, even thought that is what I
wrote. I am using code to convert to hex and then export
both hex and decimal to an excel file.

Again than you for your time.