Relation Query and Duplicates

Hello,

I have two tables:

1. Job Hours Fields: UserID, Date, JobDescription, JobHours etc.
2. Overhead Hours Fields: UserID, Date, OverheadDescription, OverheadHours etc.

I need to pull a query monthly that will show Job Hours and Overhead Hours. When I try to create a relational query I get duplicate records.

This is what I want:

Month: July 2002
  UserID: Linda

    Date: July 1, 2002

           JobDescription| JobHours| Overhead Description| Overhead Hours

              Welding         3.0          Clean-up                0.5
              Machining       1.5                               
    Date: July 2, 2002
              Welding         3.0
    Date: July 3, 2002
                                           Sick                    7.5

  UserID: John
    Date: July 1, 2002

           JobDescription| JobHours| Overhead Description| Overhead Hours

              Sanding         2.0          Clean-up                0.5
              Machining       1.5                   
    Date: July 2, 2002
              Welding         3.0
    Date: July 3, 2002
                                           Course                  7.5
etc. 
              

My problem is that the number of records from the overhead table and job table are different for a specific Day.

Does anyone have any idea how i can go about this? Thanks

Linda Received on Fri Jul 05 2002 - 15:38:23 CDT