Question Question from a newbie

[asu81]

Hi everyone!
I'm very new to Access, so please bear with me if my question may not make sense

My situation is this:
I have two tables in Access that each are linked to an Excel spreadsheet. The two spreadsheets have the same column headers.

Table 1:
Project no, date finished with task 1, date finished with task 2
11101, 2012-01-01, (empty)
11102, (empty), 2012-02-01
11103, 2012-03-01, (empty)

Table 2:
Project no, date finished with task 1, date finished with task 2
11101, (empty), 2012-01-02
11102, 2012-02-02, (empty)
11104, 2012-04-02, (empty)

Each table represent an individual's projects and which task he/she are finished with (dates). The tasks represent stages that all projects have in common.

I now want to combine these two linked tables into a single table. The results I want is this:

Combined table:
Project no, date finished with task 1, date finished with task 2
11101, 2012-01-01, 2012-01-02
11102, 2012-02-02, 2012-02-01
11103, 2012-03-01, (empty)
11104, 2012-04-02, (empty)

Can it be done, and in that case how?

Thank you!

 

[asu81]

Thanks for your reply!
My plan is to let several employees input their own work status for each project in their own spreadsheet. I then want to link all these spreadsheets to an Access file where the above transformations are made. Whenever someone inputs something new in their personal Excel sheet the Access file is also updated and the data from the files transformed as explained.

I'd appreciate if you could explain in a little more detail how I can accomplish this
Thx!

 

[asu81]

Thank you!