formula question

[Victoria]

I'm trying to convert the following excel formula to work
for access:
=IF(LEN(A3*1)<=7,RIGHT(A3,7)&IF(LEN(B3)=1,"0"&B3,B3),A3&IF
(LEN(B3)=1,"0"&B3,B3))

A3 is variable1, B3 is variable2. Anyone have any
suggestions?

 

[Duane Hookom]

Without confirming your logic, try:
=IIf(LEN(Variable1)<=7,RIGHT(Variable1,7) & IIf(LEN(Variable2)=1,"0" &
Variable2,Variable2), Variable1 & IIf
(LEN(Variable2)=1,"0"&Variable2,Variable2))