[AccessD] sorting query on 'named' collumn and use 'named' collumn in where criteria of a query

Hi Bert-Jan
No you can't, but what you can do is write a SELECT query which gets you the
fields you want plus the calculated values, then make this the source of
your existing query rather than the original table. Because the calculated
values are already in the source you can then refer to them as many times as
you like.
--
Andy Lacey
http://www.minstersystems.co.uk



--------- Original Message --------
From: Access Developers discussion and problem solving
<accessd at databaseadvisors.com>
To: accessd at databaseadvisors.com <accessd at databaseadvisors.com>
Subject: [AccessD] sorting query on 'named' collumn and use 'named' collumn
in where criteria of a query
Date: 18/06/04 07:56

>
> Dear list,
>
> in qeuries i use a lot of functions to format a value, or to get
> 'calculated' values, these functions get 'named' collumns (like .... AS
> clientnumber). This works fine.
> However when i want to use this named collumn in the WHERE - statement or
in
> the ORDER BY statement and i use the collumn name this doesn't work. Ik i
> use the same function again in the WHERE and ORDER BY statement this works
> fine, but it slows down the qeury, because the function has to be executed
> more times.
> Can i use the named collums in the WHERE and ORDER BY statement and if so
> how do i do that?
>
> I am working with A2k on WINXP and WIN2kProffesional
>
> Thanks.
>
> Bert-Jan
>
> --
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>
>
>
>

________________________________________________
Message sent using UebiMiau 2.7.2