Calculated field

T

TeeSee

When I set a criteria in a calculated field I am prompted to "Enter
Parameter Value". Does this mean that you can't set criteria for a
calculated field???
 
A

Allen Browne

In general, you need to repeat the calcuation rather than use the calculated
field name if you are to apply criteira on it.

This example repeats the calcuation in the WHERE clause:
SELECT Quantity * UnitPrice AS Amount
FROM Table1
WHERE Quantity * UnitPrice > 1000;
It would not work with Amount in the WHERE clause.
 
Top