Gustav Brock
Gustav at cactus.dk
Sat Aug 22 02:35:19 CDT 2009
Hi John There is as A.D. shows. I've found that the "unsafe" query type is safe as long as you don't perform sorting or grouping. If so, Access (or SQL) don't know what values to sort on and it fails. Another alternative to the "query-on-query" method is to use a subquery. /gustav >>> jwcolby at colbyconsulting.com 22-08-2009 07:40 >>> Thanks AD. I have been doing the query on query for a long time and just decided to see if there was an alternative. John W. Colby www.ColbyConsulting.com