Results 1 to 2 of 2
  1. #1
    danicort01 is offline Novice
    Windows 10 Access 2016
    Join Date
    Oct 2019
    Posts
    1

    Exclamation Error doing sums on queries

    Hi, so im having some trouble trying to do this query where I want to sum all my bought and selled products to customers, and then subtract this to to know how many i have left, but when i do it for some reason 1 or 2 of the 3 columns is being sum and at the same time multiplied by 2 or 3 for no reason this keep happening and i dont know how to fix it, please help. If you chek the images I bought 5 of the product number one but the sum is showing 10 and i also bought 6 of product number 2 and is showing 12, on the other hand I bought 20 of product number 3 but this one is the only right one. (image 1 is showing how I did my query, image 2 is showing my bought quantity by products, and number 3 is showing me what the query shows after the sum)Click image for larger version. 

Name:	one.png 
Views:	11 
Size:	119.7 KB 
ID:	40082Click image for larger version. 

Name:	two.png 
Views:	11 
Size:	87.4 KB 
ID:	40083Click image for larger version. 

Name:	three.png 
Views:	11 
Size:	83.6 KB 
ID:	40084 I speak portugues and also spanish if for somebody is easier to answer me the question, thanks a lot group

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,726
    Danicort01.
    consulte este link
    See this info from Allen Browne.

    Você pode escrever sua postagem em seu idioma nativo (português) e usar o Google Translate
    para criar uma versão em inglês para postar no fórum. A tradução é mais do que adequada
    para comunicação na maioria dos casos.

    Boa sorte com seu projeto

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

Similar Threads

  1. Replies: 8
    Last Post: 09-12-2018, 07:32 AM
  2. Queries, Counts, Sums, Aggregates, Pain
    By Levonas in forum Access
    Replies: 11
    Last Post: 02-04-2015, 08:04 PM
  3. Error management in queries
    By Lilian in forum Queries
    Replies: 3
    Last Post: 03-03-2011, 12:48 PM
  4. Sums of Multiple Queries
    By flsticks in forum Queries
    Replies: 5
    Last Post: 09-16-2010, 09:32 AM
  5. Error check in queries
    By devesa in forum Access
    Replies: 14
    Last Post: 05-07-2010, 09:39 PM

Tags for this Thread

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