formula question

  • Thread starter Thread starter Victoria
  • Start date Start date
V

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?
 
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))
 
Back
Top