The problem with the union query is that I am grabbing data for the recordsets from two different databases that consist of one being from Access and the other being from Foxpro. So I don't know if I will be able to use a union query that way.