Union queries

[Tim A]

I found yesterday that one of my union queries is dropping
records from it's output. In the Union query I'm
combining 3 different result sets. The first and last
result set only has 1 record in it. The middle result set
is the biggest. It has about 26,000 records in it and the
size of each record is about 250 characters. When I
remove the first and last result sets from the query I get
back 26,000 records. When I include the first and last
result set using the UNION clause the result set has
around 24,000 records in it. This seems to be a bug in
Access but I wanted to see if anyone experienced the same
problem or if they know there is a service pack to fix the
problem. I'm currently running Access 2000 SR-1. Any
help would be appreciated.

 

[Tom Ellison]

Dear Tim:

Perhaps this is the problem:

If you use UNION, it is supposed to suppress duplications. If you do not
want to suppress duplication, use UNION ALL instead.