By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
445,705 Members | 1,795 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 445,705 IT Pros & Developers. It's quick & easy.

Using alias in expression

P: n/a
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

Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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

Nov 12 '05 #2

P: n/a
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.
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.