excel query from access

[joemeshuggah]

i have a union query in access that works just fine, but when i link it to excel (data tab, get data from access, etc), the result set loses records. is there a reason why the linked query in excel would not return the same recordset as when running the query within access?