Re: dec2hex

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

Date: Thu, 29 Apr 2004 09:51:24 -0700

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.

>-----Original Message-----
>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.
>
>--
>Allen Browne - Microsoft MVP. Perth, Western Australia.
>Tips for Access users - http://allenbrowne.com/tips.html
>Reply to group, rather than allenbrowne at mvps dot org.
>
>"Donna" <anonymous@discussions.microsoft.com> wrote in
message
>news:600701c42e03$bef89c00$a601280a@phx.gbl...
>> 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
>
>
>.
>

Relevant Pages

  • Re: dec2hex
    ... There is a Hex() function that will display a number as hexadecimal, ... cannot imagine a scenario where you would want to store it both ways in the ... Tips for Access users - http://allenbrowne.com/tips.html ... > The decimal field exists in my table and I need to create ...
    (microsoft.public.access.queries)
  • Re: changing the decimal to hex
    ... If the user is storing the Hex numbers with the &H prefix then my solution ... Center for Health Program Development and Management ...
    (microsoft.public.access.queries)
  • Re: Returning a number from a hex value.
    ... Perth, Western Australia. ... rather than allenbrowne at mvps dot org. ... > can only find how to turn a number into a hex, ...
    (comp.databases.ms-access)
  • Re: Image URL from Database with spaces doesnt work
    ... %25 is the hex for the %. ... You may need to UrlDecode your data prior to ... setting or storing it. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: oracle RAW data type and dbi
    ... converts RAW data type into hex values at the time of storing. ... It converts the raw value to hex when you *read* it into a character ... That's because sqlplus reads all columns as character types (it has to ...
    (comp.lang.perl.misc)