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.
 
Back
Top