johnturgoose
Technical User
I'm losing hair fast....
I have 4 querys selecting specific data from 4 tables. I merge them with a union query. All good.
I try to use that data as a source in a mail merge in Word. It can't see the union query! Perhaps word doesn't like union queries I think. So I run a query on the union query which has no criteria and therefore is basically a copy. Word sees it. Hopes raised then crash again. Word sees the query but when the edit recipient screen opens I see there are no records. Where have they gone? Also it seems to copy across the column headings but rearranges them in a seemingly random order. Surname , address 5 , title.. etc
Any ideas guys.
Many thanks in advance.
John
I have 4 querys selecting specific data from 4 tables. I merge them with a union query. All good.
I try to use that data as a source in a mail merge in Word. It can't see the union query! Perhaps word doesn't like union queries I think. So I run a query on the union query which has no criteria and therefore is basically a copy. Word sees it. Hopes raised then crash again. Word sees the query but when the edit recipient screen opens I see there are no records. Where have they gone? Also it seems to copy across the column headings but rearranges them in a seemingly random order. Surname , address 5 , title.. etc
Any ideas guys.
Many thanks in advance.
John