An "If" formula in a Table design

[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.

 

[Douglas J. Steele]

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.