Calc field RunTot: DSum("Qty","qPicks2","[rank]>=" & [qpicks2].[ranking] & "")
I can rank them in another query, just when there is a tie in units the rank will be the same. And with the calculated field below, it is not working out. I cannot figure out though how to do a rolling total field based on the product id. Any suggestions please?