I have a restaurant database query which lists restaurants sorted by three fields:
Location field (numeric)
Cuisine type field (numeric)
Sort by name field (alphabetical)
I have records sorted by these three fields and then closed the database. But when I mail merge into a word document - some of the records come up in an odd order. Furthermore the 'Sort Records' tab in Query Options in my Word Mail Merge Pop-Up box is greyed out so I can't force the re-sort in Word.
Can anyone tell me why this is happening?
Location field (numeric)
Cuisine type field (numeric)
Sort by name field (alphabetical)
I have records sorted by these three fields and then closed the database. But when I mail merge into a word document - some of the records come up in an odd order. Furthermore the 'Sort Records' tab in Query Options in my Word Mail Merge Pop-Up box is greyed out so I can't force the re-sort in Word.
Can anyone tell me why this is happening?
