Relation Query and Duplicates
From: linda <linda_thai2001_at_yahoo.ca>
Date: 5 Jul 2002 13:38:23 -0700
Message-ID: <c0234be0.0207051238.277c214f_at_posting.google.com>
Hello,
Date: 5 Jul 2002 13:38:23 -0700
Message-ID: <c0234be0.0207051238.277c214f_at_posting.google.com>
Hello,
I have two tables:
- Job Hours Fields: UserID, Date, JobDescription, JobHours etc.
- 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 - 22:38:23 CEST