Calculated field

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

 

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