Hi,
I have attached a sample MS access file in which there are 2 tables for Incoming and outgoing letters, I want to combine the common field in these two tables to another table named "Combined" to create a report and filter data with certain criteria.
Please help me on this.
regards,
VKKT
Combine common fields in 2 Tables
-
- 2StarLounger
- Posts: 184
- Joined: 13 Jun 2018, 07:50
Combine common fields in 2 Tables
You do not have the required permissions to view the files attached to this post.
-
- Administrator
- Posts: 78454
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Combine common fields in 2 Tables
I'd create a union query to select the fields that you want from both tables, and an append query based on the union query that adds the records to the Combined table. See the attached version.
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans
Hans
-
- 2StarLounger
- Posts: 184
- Joined: 13 Jun 2018, 07:50
Re: Combine common fields in 2 Tables
Greetings:
Thanks Mr. Hans for your great support.
Regards,
VKKT
Thanks Mr. Hans for your great support.
Regards,
VKKT