Cannot get an equation editor

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Carl Gross - 23 Apr 2008 18:58 GMT

I am using Access 2002 and using SQL Server 2000 tables. I am trying to make
a simple calculated field that aquates Active to the value A, New to the
value N, etc.

I start a new query but nowhere does the option to open the equation editor
to evaluate the calculated value appear.

What is wrong?

Reply to this Message

KARL DEWEY - 23 Apr 2008 19:10 GMT

Use the IIF function.
Status: IIF(YourField] = "A", "Active", "New")
Or
Status: IIF(YourField] = "A", "Active", IIF(YourField] = "N", "New",
"Error"))

Signature

KARL DEWEY
Build a little - Test a little

> I am using Access 2002 and using SQL Server 2000 tables. I am trying to make
> a simple calculated field that aquates Active to the value A, New to the
[quoted text clipped - 4 lines]
>
> What is wrong?

Reply to this Message

Carl Gross - 23 Apr 2008 19:23 GMT

I've figured out so far that if I use a query by selection that I can use the
equation builder, but for some reason that doesn't come up. I get a view,
function and stored procedure design wizard. Now to figure our how to get
THAT wizard.

By the way, nice name (Karl).

> Use the IIF function.
> Status: IIF(YourField] = "A", "Active", "New")
[quoted text clipped - 11 lines]
> >
> > What is wrong?

Reply to this Message