dec2hex

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

Date: Thu, 29 Apr 2004 09:05:09 -0700

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