Using alias in expression

[Gunnar Liknes]

Hi,

I am trying to use the result of one expression in an other
expression by referring to its alias name. Is this possible?

here is the first: if(status>0,0,1) alias 'enabled'
and the next: anumber * enabled

I just get an errormessage saying 'enabled' is not a part of
the query...

Gunnar

[Bas Cost Budde]

Gunnar Liknes wrote:

Hi,

I am trying to use the result of one expression in an other
expression by referring to its alias name. Is this possible?

No.

If you create a new query based on the one with the alias, then yes.

--
Bas Cost Budde
http://www.heuveltop.org/BasCB
but the domain is nl

[Trevor Best]

On Sun, 8 Feb 2004 12:01:15 +0100 in comp.databases.ms-access, "Gunnar
Liknes" <gl*****@global-satcom.com> wrote:

Hi,

I am trying to use the result of one expression in an other
expression by referring to its alias name. Is this possible?

here is the first: if(status>0,0,1) alias 'enabled'
and the next: anumber * enabled

I just get an errormessage saying 'enabled' is not a part of
the query...

No, you must use the expression again, or build a query based on a
query with your aliased expressions in.

--
A)bort, R)etry, I)nfluence with large hammer.