dec2hex

From: Donna (anonymous_at_discussions.microsoft.com)
Date: 04/29/04 

Date: Thu, 29 Apr 2004 09:49:15 -0700

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

>-----Original Message-----
>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
>.
>