rrhandle8
asked on
Search multiple tables
I have multiple tables with different field names. All table are linked to a table named "RESEARCH_REPORTS". I need to search and return all fields that contain let's say the string "parent".
Union queries seem limited to just two tables.
Really stuck on this. Any suggestions?
Not opposed to using VBA.
Union queries seem limited to just two tables.
Really stuck on this. Any suggestions?
Not opposed to using VBA.
ASKER
Brian,
Can that be run in ACCESS?
Can that be run in ACCESS?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Union queries seem limited to just two tables.What makes you say this? Do you get an error message when you use more than 2 tables. I have used union queries in Access up to 10 tables without a problem.
Ron
ASKER
Thanks for the information about the UNION queries. That is what I tried first, but the results contained only data from the first query. I think it was due to the fact each table had a different field name that need to be returned. Glad to hear you can use more than two UNIONs.
I cobbled something together with VBA that runs one query at a time on each table, then stuffs it in a temp table.
I cobbled something together with VBA that runs one query at a time on each table, then stuffs it in a temp table.
Open in new window