C
Chris
Hi
I am running Access 2003 with Word 2003 and am experiencing a problem when
running a mail merge passing over a query with a sub query in it.
The query works fine and merges successfully if I don't predicate a column
in the sub-query. As soon as I do this, although the query itself returns the
correct results list, when actioning it from Word, no rows are returned.
If I remove the condition on the sub-query field the main query returns rows
back to Word.
Does anyone know if this is a limitation with Merge, or is there a work
around?
I am running Access 2003 with Word 2003 and am experiencing a problem when
running a mail merge passing over a query with a sub query in it.
The query works fine and merges successfully if I don't predicate a column
in the sub-query. As soon as I do this, although the query itself returns the
correct results list, when actioning it from Word, no rows are returned.
If I remove the condition on the sub-query field the main query returns rows
back to Word.
Does anyone know if this is a limitation with Merge, or is there a work
around?