An "If" formula in a Table design

  • Thread starter Thread starter PaulM
  • Start date Start date
P

PaulM

Hi there,
I have a field on a table called "Status1" which has a
value of 1, 2 or 3 (the data is supplied as part of an
import from another company - I have no way of changing
what I'm given).
I have another field called "Status2" in which I want a
formula If(Status1=1,"active",If
(Status1=2,"Completed","Withdrawn")).
How do I do this?
(This has to be a table as it's read by both an Excel SS
and a 3rd party DB that can't read forms or queries).

Thanks.
 
It can't be done.

Are you sure your 3rd party product can't read queries? Tables and queries
in Access look identical from outside the database.
 

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

help on a formula (match and etc..) 1
copy data from 1 cell to another. 2
Update field in table 5
Help with Query Checking 2 Fields 3
Best way to display real-time data in place? 2
Criteria doesnt open form 2
Query Help Needed 3
reference to opened form 2

Back
Top