I have the following tables:

[aageorge]

I have the following tables:

Part1 Part2
Date A B C D E Date A B C D E
7/25 30 30 30 -- -- 7/25 20 10 -- 10 --
7/26 15 45 -- 05 -- 7/25 -- 15 -- 25 10
7/27 -- 20 30 -- 30 7/25 20 -- -- 10 10

I need to get the following table:

Date A B C D E
7/25 50 40 30 10 --
7/26 15 60 -- 30 10
7/25 20 20 30 10 40

Can someone help me out with this problem

 

[ToeShot]

Access has a make table query that you could use to select the data from both tables combining the values you need and put them into one table.

HTH


Dave
ToeShot@Hotmail.com
Today Is Tomorrows Yesterday. So Why Wait