Sorting to print in order.....

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jim99 - 21 Jan 2008 17:11 GMT

Hello
Word 2000 and Access 2000.
Have a Word mailmerge document that gets data from an Access query, with
several fields. The query is sorted on one field, say "member_number".
This is the only field I'm using in the mail merge.

The merged doc does not come out in the order that "member_number" says it
should!

I don't have "SORT records" available (greyed out) on the "Query Options"
either - should I?

Reply to this Message

Doug Robbins - Word MVP - 22 Jan 2008 00:37 GMT

If the order is important, you may need to use a make table query in Access
to create a table with the data in the required order and then use that as
the data source.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> Hello
> Word 2000 and Access 2000.
[quoted text clipped - 7 lines]
> I don't have "SORT records" available (greyed out) on the "Query Options"
> either - should I?

Reply to this Message

Jim99 - 23 Jan 2008 17:31 GMT

Many thanks!
No idea how I did it, but I did the make table thing, sorted it, and the
merge works!

> If the order is important, you may need to use a make table query in Access
> to create a table with the data in the required order and then use that as
[quoted text clipped - 11 lines]
> > I don't have "SORT records" available (greyed out) on the "Query Options"
> > either - should I?

Reply to this Message