dec2hex

  • Thread starter Thread starter Donna
  • Start date Start date
D

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
 
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.
 
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.
 
Back
Top