Re: dec2hex

From: Allen Browne (AllenBrowne_at_SeeSig.Invalid)
Date: 04/29/04 

Date: Fri, 30 Apr 2004 00:43:04 +0800

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: ecb works , but cfb and cbc dont ( php )
    ... I just convert the binary to hex and store it all in a ... i can then ftp, email this file anywhere and decrypt it ... stuff right takes a considerable amount of knowledge. ...
    (sci.crypt)
  • Visual Basic Hex conversion
    ... I am getting hex numbers in from an RS-232 source and coverting them to store ... in a database. ...
    (microsoft.public.vb.general.discussion)
  • Re: String to Octal
    ... will store the octal number 777. ... But it atoi does this as an interger, ... The input string is "309" ... read as hex, *endp='$', ...
    (comp.lang.c)
  • Re: Visual Basic Hex conversion
    ... > I am getting hex numbers in from an RS-232 source and coverting them ... > to store in a database. ... forces VB to store it in 32 bits instead. ...
    (microsoft.public.vb.general.discussion)
  • Re: dec2hex
    ... I'm not actually storing it, even thought that is what I ... I am using code to convert to hex and then export ... rather than allenbrowne at mvps dot org. ... >> The decimal field exists in my table and I need to ...
    (microsoft.public.access.queries)