Query returns duplicated values for some cells

[erict]

I'm trying to execute a query which is looking at data from 2 different tables and most of the data fields in the tables are the same. For instance table 1 has Dept, Res, Period_date, & Available Hrs and table 2 has Dept, Res, Period_date, Project & Forecast Hrs. The results I'm looking for are as follows:

Dept Res Period_date Project Forecast Hrs Available Hrs
11 A 11-02-07 123 XXXXX
11 A 11-02-07 456 XXXXX
11 A 11-02-07 789 XXXXX
11 A 11-02-07 012 XXXXX
11 A 11-02-07 XXXXX

But the "Available Hours" are duplicated in the preceeding 4 rows.
Thanks for any advice on this.

 

[KenHigg]

Sorry to be anal about this but unless you can make it pretty easy for someone to look at your data and see what’s going on they're going to be less apt to take a stab at helping. I fixed the following in notepad in a non proportional font and copied it back wrapping it in code tags to make it easier to read. Is this how you meant for it to be interpreted?

Dept Res Period_date Project Forecast Hrs Available Hrs
11   A   11-02-07    123     XXXXX
11   A   11-02-07    456     XXXXX
11   A   11-02-07    789     XXXXX
11   A   11-02-07    012     XXXXX
11   A   11-02-07            XXXXX

ken

 

[erict]

Thank you for your patience. I meant for the data look like that but the last row of data has the x's under the Available Hrs column instead of the Forecast Hrs column.
And in the query I'm executing, the Available Hrs data is repeated in the four preceeding columns. Kind of like each time there is a row of data with that Period_date, the Available Hrs is repeated. I hope this is clearer than the last attempt. Thanks again for your time and patience.

 

[KenHigg]

You're kind of losing me. Any way you can post a sample database with the some of the two tables in it?

 

[erict]

Attaching d-base

I've attached the d-base if you have time to look at it. Thank you

 

[KenHigg]

Don't see it - You may have to zip it up first...