So I have a simple query to get sales results based on properties and then a grand total:
This is my SQL:
I expected to get results such as:
Property Amount Running sum
A 5000 5000
B 2500 7500
C 1000 8500
D 2500 11000
Instead I get:
A 5000 11000
B 2500 11000
C 1000 11000
D 2500 11000
What am I doing wrong?
mafhobb
This is my SQL:
Code:
SELECT tblReservations.PropertyName, Sum(tblReservations.ResAmount) AS SumOfResAmount, DSum("ResAmount","tblreservations") AS Expr1
FROM tblReservations
GROUP BY tblReservations.PropertyName
ORDER BY tblReservations.PropertyName;
I expected to get results such as:
Property Amount Running sum
A 5000 5000
B 2500 7500
C 1000 8500
D 2500 11000
Instead I get:
A 5000 11000
B 2500 11000
C 1000 11000
D 2500 11000
What am I doing wrong?
mafhobb