Then perhaps you need to post your sample data and merge document so we can see what you are doing. Sorting the data shouldn't remove records - but filtering it might.
An alternative might be to link the Excel data into an Access Database and create a report that shows the data in the format you want it.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
|