Union with an OLE Object

[Guest]

Hello!

I'm attempting to union two tables, both having 4 identical fields, and with
both tables containing OLE objects that correspond to the rest of the fields.
I can union the first three fields, but it will not let me union with OLE
objects (or hyperlinks, etc.).

Does anyone have an idea about how I might be able to incorporate the
corresponding "OLE field" data into the resultant union table?

Thanks!!!

 

[Arvin Meyer [MVP]]

If it's a hyperlink, change it to a text field and use code to follow the
hyperlink. If it's an image, you are out of luck if you want to display as a
continuous form, but you can lookup the object on-the-fly in single form
view.

 

[John Vinson]

Hello!

I'm attempting to union two tables, both having 4 identical fields, and with
both tables containing OLE objects that correspond to the rest of the fields.
I can union the first three fields, but it will not let me union with OLE
objects (or hyperlinks, etc.).

Does anyone have an idea about how I might be able to incorporate the
corresponding "OLE field" data into the resultant union table?

Thanks!!!

Try UNION ALL - which won't attempt to deduplicate the OLE objects.

John W. Vinson[MVP]

 

[Guest]

Try UNION ALL - which won't attempt to deduplicate the OLE objects.

John W. Vinson[MVP]

Perfect! Thanks, John!