Re: order by 2 columns in ACE

Peter, John (and anyone who replies before this hits the list!) Thanks for your help, and even more for your patience. I had never heard about or come across "UNION" before, so I guess my question must have looked like a complete no-brainer. :-) I've tried it out, and it works perfectly. The user who requested this particular report was also suitably impressed! If only I'd sent the request 7 hours ago !! Cheers, Richard. ----------------------------------------------------------------- | _ /\\ | Richard Thomas | | \\ 0_ | r.thomas@csl.gov.uk | | \\ / | | | oo/ | "20 Regal and a four-pack, | | / \\ | I guess I'm set for the night" | | \\_/ | - "TV Tan" The Wildhearts | -----------------------------------------------------------------