From: Chris Robinson 

Like this?:

SELECT *
FROM [select f1 from table1 union select f2 from table2]. AS mystuff ORDER
BY mystuff;

This doesn't work - it prompts for a parameter value.  It doesn't bother me
too much cos it's in numeric order with no duplicates anyway.

Thanks again,
Chris.

Adam Flinton wrote:

> John Beamish wrote:
> > SELECT *
> > FROM [select f1 from table1 union select f2 from table2]. AS mystuff;
> >
>
> Followed by an order statement wrapping that.
>
> Adam
>
> > "Adam Flinton"  wrote in message
> > news:3ebb74d1{at}w3.nls.net...
> >
> >>Why didn't union/union all followed by an orderby statement work?
> >>
> >>I'm sure access has union/union all & order by (nb last used Access:
> >>version = 97 in about 1999/2k)
> >>
> >>Union is for doing just what you've set out below.
> >>

--- BBBS/NT v4.01 Flag-4