Union Query

  • Thread starter Thread starter James
  • Start date Start date
J

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.
 
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.
Click to expand...

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