Sum in a query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a query that I have 2 columns each with a number in it ( in some of
the entries there is only 1 number in the first column) and a third column
with the total of the 2 columns (if there is a number in the 2nd column), and
in one of my enteries, the sum is correct but in the total column it is
dividing the number by 2, do you know why this would be happening?
 
Post the SQL. Or the contents of the query grid.

You can get to the SQL by right-clicking on the Query Designer and selecting
'SQL View' from the drop down menu. Then simply copy the text of the SQL and
paste it into your post.
 
I have a query that I have 2 columns each with a number in it ( in some of
the entries there is only 1 number in the first column) and a third column
with the total of the 2 columns (if there is a number in the 2nd column), and
in one of my enteries, the sum is correct but in the total column it is
dividing the number by 2, do you know why this would be happening?
Click to expand...

Not a clue; obviously there is something wrong with the query, but I
can't see the query from here.

Please open the Query in SQL view and post the SQL text here.

John W. Vinson[MVP]
 
Back
Top