Click here to Skip to main content
14,845,586 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi -
I'm trying to display a report that pulls information from two different tables in one MDB database file. I have two categories of information - one category is event information and the other is action information. Both of these categories have:
- Titles
- Dates
- Locations
I'd like to be able to pull these two different sets of data together into one list using the similar characteristics listed above. Could u please help me to do this? I've read it could be done using Common Fields but I can't seem to locate how to set this up. Thank you!
Posted
Updated 13-Jul-10 7:52am
v2

1 solution

Use UNION in your query.
Form a query where you fetch these details from both the table. Since both are having similar characterstics, use UNION to collate the data and use it as datasource to your report.
   

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900