Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Mar 2002
    Location
    Maryland, USA
    Posts
    22
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Access/Query (2000)

    I have a table that has Work Order, part ID and Cost of parts.
    Then I have another table with Work Order ID, Mechanic and Hours..
    I created a relationship with the 2 by Work Order Number.

    On my data entry I may have 5 parts and 2 Mechanics.

    When I put these 2 tables together I get the parts I need but my mechanics duplicate and I know why because there will be 5 lines for parts and it thinks mechanics should have 5 mechanic entries. Does anyone know a formula that I can use to field for mechanic if blank skip and leave it blank or 0.00...

    I hope you will understand this.

  2. #2
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Access/Query (2000)

    What are you really trying to do? <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>
    What you have is two tables that have multiple entries per Work Order. It doesn't make sense to me to join these 2 tables.
    Pat

  3. #3
    New Lounger
    Join Date
    Mar 2002
    Location
    Maryland, USA
    Posts
    22
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access/Query (2000)

    I have to give a grand total of works hours and total parts one report

  4. #4
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Access/Query (2000)

    Theres no ned to join the queries, all you need are two text boxes on your report as DSums.

    For the TotalParts textbox put the following in the Control Source:
    =Dsum("Cost of Parts","WOParts table")

    and for the work hours:
    =Dsum("Hours","WO Hours")

    You will have to put your own table names and field names instead of mine.
    Pat <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •