Hi there

I need your help and expertise in this situation, please

FieldA   Estimation      Existing             tblA
            ResultA          ResultA
21       021                   021                   021
36       024                    24                    024
18       012                    12                    012
775      307                  307                   307
A03      A03                A03                    A03  
6         006                  006                    006
0         000                  000                   000
2843   B1B                  B1B                  B1B

table A is list of Hex numbers, and field A is numbers which have a mix
format decimal and hex, then also mix length. What i'm trying to do is to
match Field A with tblA with condition:

IF fieldA = table A,add 0 or 00(with lentgh lest than 2),then if field A =
table A,choose fieldA, if false change field A to hex. as below queries. The
existing resultA as example above. And the estimatation result as above.

ResultA: IIf([FieldA]=[tblA],Right("00" & [FieldA],3),IIf([FieldA]=[tblA],
[FieldA],Hex([FieldA])))

Can you please advise me, what is the right queries, so as the i will get the
estimation result.

thank you