question

[Victoria]

I have a formula from excel that I'm trying to convert to
access- either in a module or in a query. Think of A3 as
variable1, B3 as variable2. Any suggestions?
=IF(LEN(A3*1)<=7,RIGHT(A3,7)&IF(LEN(B3)=1,"0"&B3,B3),A3&IF
(LEN(B3)=1,"0"&B3,B3))

 

[Douglas J. Steele]

Access uses IIf rather than the If that Excel uses. Other than that, it may
very well convert as is.

 

[Duane Hookom]

More answers in other NGs where you asked the same question. Please limit
your postings to a single NG.