Access merge help_2

[lmnorms1]

Hello,
I have an access db that as several tables. I want to create one table
(or file).
The tables have keys. Some tables might not contain information for
the keys.

For example:

Table a Table B Table c Table d
Rec 1 Rec 1 Rec 1 Rec 1
Rec 2 Rec 2 Rec 2

How do I create one table that contains all information (including
empty records for tables that don’t have corresponding info.) where
all records match based on table A having a value of X in one field?

Table 5 (or File)
A Rec1
B Rec1
C Rec1
D Rec 1
A Rec2
B Rec2
C Empty
D Rec2

Marker for original table must be present on output.

Thank you,
(e-mail address removed)

 

[pietlinden]

Hello,
I have an access db that as several tables. I want to create one table
(or file).
The tables have keys. Some tables might not contain information for
the keys.

For example:

Table a         Table B         Table c         Table d
Rec 1           Rec 1           Rec 1           Rec 1
Rec 2           Rec 2                              Rec 2

How do I create one table that contains all information (including
empty records for tables that don’t have corresponding info.) where
all records match based on table A having a value of  X in one field?

Table 5 (or File)
A Rec1
B Rec1
C Rec1
D Rec 1
A Rec2
B Rec2
C Empty
D Rec2

Marker for original table must be present on output.

Thank you,
(e-mail address removed)

outer join them.

 

[lmnorms1]

outer join them.

Do you have an example?