Cannot get an equation editor

  • Thread starter Thread starter Carl Gross
  • Start date Start date
C

Carl Gross

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?
 
Use the IIF function.
Status: IIF(YourField] = "A", "Active", "New")
Or
Status: IIF(YourField] = "A", "Active", IIF(YourField] = "N", "New",
"Error"))
 
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).

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

--
KARL DEWEY
Build a little - Test a little


Carl Gross said:
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?
Click to expand...
Click to expand...
 
Back
Top