using calculated columns in criteria

  • Thread starter Thread starter Max
  • Start date Start date
M

Max

I have a column in my query that does a simple calculation expr1: When I
try to use this "expr1" in the criteria of another column is asks me to
enter expr1.

Why does it not use the calculated value?
Is it possible to use this calculation in another part of the query?
 
"expr1" is an Alias and you cannot use the Aliases in the criteria.

You need to use the expression that "calculates" expr1.
 
Max

Van points out the problem with trying to use an Alias within a single
query. Another approach for you might be to build your first query with the
calculated field, then build a second query, based on the first, using the
calculated value.

Consider posting your SQL statement for further suggestions.
 
Back
Top