Hexadecimal to decimal 1

[mkallover]

If I have a field in a database that contains hexadecimal numbers, is there a way that I can convert these to decimal through a query?

 

[Golom]

Try

Val("&H" & [HexField])

 

[mkallover]

Thanks, I'll give that a go.

 

[Golom]

You might expand it to

Val("&H" & [HexField] & "&")

The first version I gave you can hit the "integer trap" ... which means that it will attempt to convert to an integer data type and, if the HEX number is too large (i.e. > 32767), the conversion will error.