hi,
İ cant use theese codes in may access query
i can use it oracle query but it doesnt work in access query
SUM(SalePrice) OVER(PARTITION BY OrderCategory order BY orderDate)
i have a table lıke this and i want last column sum(saleprice)lıke ,
OrderCategory orderDate SalePrice
sum(saleprice)
xxxx 01.01.2020 50
50
xxxx 10.02.2020 150
200
xxxx 01.03.2020 175
375
What I have tried:
<pre>SUM(SalePrice) OVER(PARTITION BY OrderCategory order BY orderDate)