I am using Access 2000 which has 2 tables which are exactly the same structure, only contain slightly different data. I would like to perform just 1 query and have the results of both tables show up on just 1 report, currently using two queries and 2 reports now. I don't believe a join is necessary, at least I am this is the direction I am currently headed. Or, is a join necessary. Thank you for any assistance.
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!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Combine data from 2 tables into 1 report using 1 query 1
- Thread starter vamoose
- Start date
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question