Union Query

[James]

I have created an access database that links to tables located in seperate
databases. (All tables contain exactly the same field names and data type.)
When linking to these tables , the hyperlinked information is not lost.
However, whenever i perform a union query on all of the linked tables, the
information is nolonger hyperlinked and instead information is instead shown
as its file location.

Are there any ways to fix this.

 

[John W. Vinson]

I have created an access database that links to tables located in seperate
databases. (All tables contain exactly the same field names and data type.)
When linking to these tables , the hyperlinked information is not lost.
However, whenever i perform a union query on all of the linked tables, the
information is nolonger hyperlinked and instead information is instead shown
as its file location.

Are there any ways to fix this.

A Hyperlink field is a modified Memo datatype, and UNION queries truncate Memo
fields. Try using UNION ALL instead of just UNION.