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

Andy and Gustav,

many thanks, never thought of that, although i use queries as a source for
other reasons... ;-)
I'll give it a try!

Bert-Jan

----- Original Message ----- 
From: "Andy Lacey" <andy at minstersystems.co.uk>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Sent: Friday, June 18, 2004 10:46 AM
Subject: Re: [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
>
> -- 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com