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))
 

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

question 2
Need to migrate phone no into the next record if the family 1
Excel EXCEL - Set non-continuous PrintArea via Function / Name 0
Set non-continuous PrintArea via Function / Name 0
SUM / COUNT formula 3
Help with formula 2
Function help required... Between funtion 2
Altered pasting functionality 3

Back
Top