I am trying to create an Excel Pivot Table using a ADO connection. The query uses a UNION statement to connect two separate SELECT's. The recordset returned is missing a single record, throwing off my result. Yet if I revert to bringing the data down and putting it on a spreadsheet in two steps, all is correct. Is this a known problem? Is there a work around?

Dave

__________________
Dave

Use Union All

Select * from employees1
union all
select * from employees2


Union removes duplicates, you may have duplicates in your queries.



Sal

Thanks. In our 60,000+ records we do have to identical items. Makes me think of something Holmes once said, or was it Spock?

Dave