Results 1 to 5 of 5
  1. #1
    Jkor is offline Novice
    Windows 10 Office 365
    Join Date
    Aug 2022
    Posts
    2

    Summary Report

    Have a query with list of work orders and trying to only get summary of Finish Good cost and Labor Hours reported. Below is an example:



    wo.num part.num description qtyUsed code cost dateFinished
    101:001 ELD-M0102-002- 1.1 Frame with Rods 2 ea 102.505274634 3/25/2022 9:35:00 AM
    101:002 ELD-M0102-002- 1.2 Frame with Rods 2 ea 89.712984834 3/25/2022 9:36:00 AM
    101:003 ELD-M0102-002- 2.1 Frame with Rods 2 ea 110.180648514 3/25/2022 9:36:00 AM
    101:004 ELD-M0102-002- 2.2 Frame with Rods 2 ea 107.622190554 3/25/2022 9:36:00 AM
    101:004 ELD-MANF-0001 FRAME ASSEMBLY 4' X 8' 2 ea 79.479152994 3/25/2022 9:36:00 AM
    101:001 ELD-MANF-0001 FRAME ASSEMBLY 4' X 8' 2 ea 79.479152994 3/25/2022 9:35:00 AM
    101:003 ELD-MANF-0001 FRAME ASSEMBLY 4' X 8' 2 ea 79.479152994 3/25/2022 9:36:00 AM
    101:002 ELD-MANF-0001 FRAME ASSEMBLY 4' X 8' 2 ea 79.479152994 3/25/2022 9:36:00 AM
    101:002 ELD-MANF-0014 -1 .250 ROD 40 ft 10.23383184 3/25/2022 9:36:00 AM
    101:003 ELD-MANF-0014 -1 .250 ROD 120 ft 30.70149552 3/25/2022 9:36:00 AM
    101:004 ELD-MANF-0014 -1 .250 ROD 110 ft 28.14303756 3/25/2022 9:36:00 AM
    101:001 ELD-MANF-0014 -1 .250 ROD 90 ft 23.02612164 3/25/2022 9:35:00 AM
    101:001 Frame Assembly Labor Labor 2.866 hr 0 3/25/2022 9:35:00 AM
    101:003 Frame Assembly Labor Labor 7.416 hr 0 3/25/2022 9:36:00 AM
    101:004 Frame Assembly Labor Labor 6.416 hr 0 3/25/2022 9:36:00 AM
    101:002 Frame Assembly Labor Labor 2.5 hr 0 3/25/2022 9:36:00 AM

  2. #2
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    What do you expect as a result? Are all those records relating to one finished goods?

  3. #3
    Bulzie is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    Nov 2015
    Posts
    1,463
    Agreed not sure you gave enough info for what you are asking but you could create another query and use this query as the source, bring in Description and qtyUsed, use the Totals tab/icon and for Description select GroubBy as the Total: value and criteria select "Labor", then next field select qtyUsed select Sum in Total: row. Something like that.

  4. #4
    Jkor is offline Novice
    Windows 10 Office 365
    Join Date
    Aug 2022
    Posts
    2
    Quote Originally Posted by CJ_London View Post
    What do you expect as a result? Are all those records relating to one finished goods?
    For this report I am trying to get total by Work Order with total cost on "Frame with Rod" & total "labors", 19.198hrs.

    Not needing detail or all parts on that W/O.

  5. #5
    Join Date
    May 2018
    Location
    Living in Scotland UK
    Posts
    1,557
    Hi
    Would be easier if you uploaded a copy of the Db.
    You can PM me if you need further help.
    Good Reading https://docs.microsoft.com/en-gb/off...on-description

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 10-14-2016, 07:00 AM
  2. Summary Report
    By balajigade in forum Access
    Replies: 4
    Last Post: 02-05-2016, 09:24 PM
  3. Report with summary data
    By markh719 in forum Access
    Replies: 1
    Last Post: 11-26-2014, 02:25 PM
  4. Replies: 2
    Last Post: 08-25-2010, 01:42 PM
  5. Summary Report Help Please?
    By solitaire in forum Reports
    Replies: 3
    Last Post: 03-03-2006, 08:10 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums