question

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

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))
 
Access uses IIf rather than the If that Excel uses. Other than that, it may
very well convert as is.
 
More answers in other NGs where you asked the same question. Please limit
your postings to a single NG.
 
Back
Top