Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Union Query

Status
Not open for further replies.
jdhj

jdhj

Programmer
Joined
Aug 7, 2003
Messages
1
Location
US
I have two tables that contain matching fields. Both also have a hyperlink field and an OLE field (for a map). As you probably know, I can't use these fields when doing a union query. Any workarounds you know of. Thanks in advance....
 
Sort by date Sort by votes
Have you tried linking your union query to a standard query? I don't know if this will work, just trying to give you a couple ideas.

Good Luck!
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Anthony343242
  • Locked
  • Question Question
MS ACCESS UNION ALL with Attachment data type
2
Replies
29
Views
9K
Anthony343242
Anthony343242
jjMedrano
  • Locked
  • Question Question
UNION ALL with Attachment data type
Replies
8
Views
892
Andrzejek
Andrzejek
MattGreer
  • Locked
  • Question Question
Is it "bad" to have a Lookup table/query in a table?
Replies
4
Views
449
MattGreer
MattGreer
Brianfree
  • Locked
  • Question Question
Query to match records in two tables
Replies
4
Views
508
Brianfree
Brianfree
Magnolia1
  • Locked
  • Question Question
Hello, I need help with my query. I
Replies
2
Views
377
Magnolia1
Magnolia1

Part and Inventory Search

Sponsor

Back
Top