Access 2010 Mailmerge to Word Query Dataset Empty 1

[VegasUser]

Mailmerge has been working until....

I have a query that is returning a dataset in Access but when I execute the query in the mailmerge function it's empty.

I've checked the querydef in the function to see if it has been truncated but it's not. I can execute the query from the function and get the correct dataset. I've also verified that all the fields in the Word doc match the query fields.

When linking a test dummy doc from Word to the same query there's no data. I've recreated the merge document several times and it still won't work.

I've done hundreds of these and never encountered this problem. Is this an issue wiith Word? Any thoughts?
Thanks!

 

[vbajock]

Since this forum concerns VBA coding, is there any chance you could post your code?

 

[VegasUser]

Thanks for replying vbajock

I was fighting with this again today and discovered that the field containing the data I was querying against is a multi-value text field. Therefore, Access could execute the query but Word couldn't interpret it and had no data.

I tried embedding the column in a sub-query but Word still evaluates it as one query, so I'm having to create a temp table.

Then it worked fine!

Thanks again for helping!