How can you do hex to decimal conversions in queries? 2

[ScottyP]

I have a table with hexadecimal values in each record. I need to build a query that will convert the hex values to decimal values. Access 97 and 2000 have the "hex" function that does a decimal to hex conversion, but I do not know how to do the reverse. Ideas?

Thanks

 

[Guest_imported]

This should do it for ya

Dim myval As Double

myval = Val("&Hffff&&quot

The &H****& tells the Val function that it being passed a Hex value.

 

[ScottyP]

Thanks Philly, but that only returns 65535, the decimal value of hex ffff. What I need is for it to return the decimal of the value in field "hexnumber" for example. I tried this before: val(&H[hexnumber]), but that didn't work.

 

[THoey]

You need to append the &H to the value of that field:

val("&H" & [hexnumber])

Try that... Terry M. Hoey
th3856@txmail.sbc.com
While I don't mind e-mail messages, please post all questions in these forums for the benefit of all members.

 

[ScottyP]

th3856,
That worked! Thanks a million, I've spent more time than I care to tell on this one.

 

[DataEmbryo]

This will return negative values for hex numbers like: B44E. How do I force positive numbers? I tried using Val("&H0000" & [hexnumber]) after seeing on this converter that adding zero forces a positve number.

http://www.eclectic-web.co.uk/awr/hex2dec.php?num=0B44E

 

[DataEmbryo]

FYI

val("&H" & [hexnumber] & "&")

forces positive numbers. Otherwise hex numbers begining with 8 thru F will return negative decimal numbers.