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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

formula question 1
SUM / COUNT formula 3
Altered pasting functionality 3
Function help required... Between funtion 2
NESTED ANDIF STATEMENTS 1
If OR formula 1
Multiple conditions 2
Supress DIV/0 2

Back
Top