using calculated columns in criteria

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

 

[Van T. Dinh]

"expr1" is an Alias and you cannot use the Aliases in the criteria.

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

 

[Jeff Boyce]

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.

 

[Max]

I did not know I could not use the alias....thanks for the reply