Sum in a query

J

Jenn Civello

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?
 
C

Chaim

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.
 
J

John Vinson

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]
 
Top