Results 1 to 2 of 2
  1. #1
    steven7 is offline Novice
    Windows 8 Access 2010 64bit
    Join Date
    May 2016
    Posts
    13

    Double Totals

    Hi,



    I am having problems with a query.

    Basically, its for production line totals. The sheet I am linking to, has Item numbers and Trans quantity and filter for only IC in DO Ty column. I'm showing only 1 Item number from thousands here. This total comes back as 434 which is correct. But what I need to do after that, is organise all the Item numbers into production lines so I can have a total for that line. When I add another table in, link it by Item number and display the line number, the total for this Item number comes back as double. I have used the group by sum on Trans quantity. Some Item number totals are correct and some are out. Please help.

    Item Number Branch Plant Location Do Ty Trans. Date Trans Ref Trans Quantity
    BC09016 MKM 10C RI 16/02/2017 EP4205 -50.000
    BC09016 MKM 10C RI 16/02/2017 EP4205 -200.000
    BC09016 MKM 10C IC 17/02/2017 WO 100.000
    BC09016 MKM 10C IC 17/02/2017 WO 34.000
    BC09016 MKM 10C IC 17/02/2017 WO 100.000
    BC09016 MKM 10C IC 17/02/2017 WO 100.000
    BC09016 MKM 10C IC 17/02/2017 WO 100.000
    BC09016 MKM 10C IB 17/02/2017 WO 0.000

  2. #2
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    it will be because your other table has duplicate records as far as the item number is concerned

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

Similar Threads

  1. Query detail totals vs. Summary Totals do not match?
    By aellistechsupport in forum Queries
    Replies: 9
    Last Post: 01-15-2016, 11:36 AM
  2. Similar to totals and Grand totals
    By Thompyt in forum Reports
    Replies: 14
    Last Post: 01-24-2015, 06:39 PM
  3. Unusual Sub Totals & Totals in Groups.
    By Robeen in forum Reports
    Replies: 12
    Last Post: 03-20-2012, 08:55 AM
  4. Replies: 5
    Last Post: 12-06-2011, 11:18 AM
  5. Month totals and Year totals
    By marksnwv in forum Access
    Replies: 1
    Last Post: 08-05-2011, 10:13 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