MS ACCESS 97 QUERY

Question

I need to do a very simple select sum on orders table but its bringing back count of 82 locations when their is only one location for the first data

SELECT Orders.OrderNumber, sum(Orders.Location)
FROM ORDERS
GROUP BY  Orders.OrderNumber,Orders.Location

What am I missing in such a basic query ?

Answer 1

You don't need Orders.Location in Group By Clause

Try this

SELECT Orders.OrderNumber, sum(Orders.Location)
FROM ORDERS
GROUP BY  Orders.OrderNumber

Answer 2

You need to remove the Group By on Location:

SELECT Orders.OrderNumber, Sum(Orders.Location) AS SumOfLocation
FROM Orders
GROUP BY Orders.OrderNumber;