D
Duncs
I'm not sure if it's merging tables, but here goes...
I have two tables as follows:
Table 1
CustName
Serial One
Date Registered
Table 2
CustName
Serial Two
Date Registered
What I want to do is create a new table as follows:
Table 3
CustName
Serial One
Date Registered One
Serial Two
Date Registered Two
Some customers may appear on Table 1 & Table 2, some may appear only
in Table 1 and some only in Table 2. So, I can see the following
possible record entries in Table 3:
CustName Serial One Date Reg One Serial Two Date Reg Two
Jones A123456 13/01/10 B123456
10/02/10
Smith A523652 27/01/10
Brown
D52135A 05/02/10
Can someone tell me how to do this, as it's driving me mad!!
TIA
Duncs
I have two tables as follows:
Table 1
CustName
Serial One
Date Registered
Table 2
CustName
Serial Two
Date Registered
What I want to do is create a new table as follows:
Table 3
CustName
Serial One
Date Registered One
Serial Two
Date Registered Two
Some customers may appear on Table 1 & Table 2, some may appear only
in Table 1 and some only in Table 2. So, I can see the following
possible record entries in Table 3:
CustName Serial One Date Reg One Serial Two Date Reg Two
Jones A123456 13/01/10 B123456
10/02/10
Smith A523652 27/01/10
Brown
D52135A 05/02/10
Can someone tell me how to do this, as it's driving me mad!!
TIA
Duncs