K Kolob Oct 14, 2003 #1 I havn't found a way to complete this in access. I always have to do it in excell. Please help and thanks in advance. Kolob
I havn't found a way to complete this in access. I always have to do it in excell. Please help and thanks in advance. Kolob
D Douglas J. Steele Oct 14, 2003 #2 Append &H in front of the Hex value, and use CLng to convert to a long. Rather than HEX2DEC("A5"), you'd use CLng("&HA5")
Append &H in front of the Hex value, and use CLng to convert to a long. Rather than HEX2DEC("A5"), you'd use CLng("&HA5")
