Is this possible?

[ThisIsntMyRealName]

I have two union queries in two different databases. They both have similar input files, 3 files with the same # of records and an amount field that totals the same for all 3, except some other fields are slightly different. When I do the union for each side, the combined output of the union queries come up with a different number of records and a different amount total. ACCESS 2007.

Does this seem like a corruption?

 

[Joe4]

UNION queries drop all "duplicate" type records, meaning if you have a record in one table/query that is exactly the same as one in a different table/query, when those two tables/queries are joined in a UNION query, only one of those records will be returned, not both.

Could that be what is going on?

 

[alansidman]

Further to Joe's post, if this is the case and you want all the records, change the query to a UNION ALL.

Alan