Union Query and Mail Merge sorting problem
Posted on 2006-06-17
I work with test procedures, inspection reports and work items. The work items are of 2 different work types i.e. Type A and Type B
I have a union query that ties 3 different queries.
The test procedure is enter into selector form's text box and the command buttton opens the union query.
The union query gathers Type A (Query #1) and Type B (Query #2) work items assigned to the test procedure. The third Query adds a STATEMENT that tells the inspector that all of Type A and B work types have been gatther and the report is ready for them to add their hand written decrepancies to the report.
Everything is working fine, but when press the "Publish It In Word" command button to get ready for the mail merge. The STATEMENT does not always appear at the bottom of the Word table.
How do I fix the queries in order for the STATEMENT always appears at the bottom of the Word table? .