Merging with MS Word

C

Clyde Thorne

I maintain a large database with customers names and when I merge the names
into a Word document, the names no longer come out in alphabetical order. I
can't seem to find rhyme or reason for the mix up. Any ideas how to keep
them in order?
 
R

Rick Brandt

Clyde Thorne said:
I maintain a large database with customers names and when I merge the names
into a Word document, the names no longer come out in alphabetical order. I
can't seem to find rhyme or reason for the mix up. Any ideas how to keep
them in order?

Are you merging a Query with an explicit sort order or the Table? You can only
guarantee the order by using a query. The order that you *see* records when
looking at a Table directly cannot be relied upon in any other operation.
 
Top