Results 1 to 1 of 1
  1. #1
    Join Date
    Feb 2004
    Posts
    1

    Unhappy Unanswered: Report Help for Access Newbie

    Howdy to All,
    I'm chasing a problem with trying to write a report that summarizes work order detail and I'm comepletely stuck. I've attached a demo db with three tables that reproduces my problem.

    WO Table: represents the work order itself
    WOID, Date

    EMP table: represnts employee time per WO
    WOID, EMP_NO, EMP_HRS

    EQUIP table; represents equipment time per WO
    WOID, EQUIP_NO, EQUIP_HRS

    Any given work order can have 1 to many Employees or Equip's involved. When a new work order is entered, multiple EMP and/or EQUIP records are created. This seems to be proper based on what I know. My problem is I need to build a report to essentially re-assemble the WorkOrders with detail for each Employee or Equip.

    The query(s) to do this are eluding me. The two in the demo produce results i did not expect. Especially the aggegate query.

    Can anyone offer me some help?

    Much Thanks in advance
    Attached Files Attached Files

Posting Permissions

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