×
×ייל המבולבל
Hope you can help,
I have a groupby query that gets data from several tables called QOrders.
The records are sorted by PurchaseDate and then by PurchaseID (Primary Key).
I would like to make a running sum in a subform of PurchaseAmount according
to the same order (first sort by date then by ID).
Since I could only manage to sort by ID even though I entered date as
criteria, I wonder if it would be better to add a records counter that will
count according to my sorting order.
Then I plan to use this counter as criteria for the running sum.
My query looks like this
PurchaseDate PurchaseID PurchaseAmount Counter
12/3/07 123 500 2
12/3/07 125 250 2
12/4/07 113 200 3
12/5/07 153 100 4
Tried with Dcount to make the counter (used format(Purchasedate,"general
number") but as you can see, it groups the counter for eadh date.
thanks
I have a groupby query that gets data from several tables called QOrders.
The records are sorted by PurchaseDate and then by PurchaseID (Primary Key).
I would like to make a running sum in a subform of PurchaseAmount according
to the same order (first sort by date then by ID).
Since I could only manage to sort by ID even though I entered date as
criteria, I wonder if it would be better to add a records counter that will
count according to my sorting order.
Then I plan to use this counter as criteria for the running sum.
My query looks like this
PurchaseDate PurchaseID PurchaseAmount Counter
12/3/07 123 500 2
12/3/07 125 250 2
12/4/07 113 200 3
12/5/07 153 100 4
Tried with Dcount to make the counter (used format(Purchasedate,"general
number") but as you can see, it groups the counter for eadh date.
thanks