Formula To Convert A HEX Value to Decimal

[jturner]

I am having a problem finding a conversion from HEX to DEC in Access. I used
HEX(number) to move from DECimal to HEX but how do I convert back?

Any help is appreciated!

 

[Mike Labosh]

I am having a problem finding a conversion from HEX to DEC in Access. I

used
HEX(number) to move from DECimal to HEX but how do I convert back?

I just did this in the VBA Immediate Window:

? Hex(47)
2F

? Val("&H2F")
47

? Val("&H" & Hex(47))
47

--
Peace & happy computing,

Mike Labosh, MCSD

"It's 4:30 am. Do you know where your stack pointer is?"