Stuart McLachlan
stuart at lexacorp.com.pg
Tue Apr 27 21:29:28 CDT 2004
On 27 Apr 2004 at 21:24, Steve Goodhall wrote: > Has anybody had any weird problems with UNION queries. I have a UNION of 4 > SELECTS that returns 257 records when opened in the query tool, but only 18 > when processed as a recordset. Running in A2K. Any thoughts? > Are all 257 different? I'd guess that the Query will have the UniqueRecords property set to No. Try using UNION ALL in the recordset. -- Lexacorp Ltd http://www.lexacorp.com.pg Information Technology Consultancy, Software Development,System Support.