Are you asking for a running sum? If so, you MUST have a unique identifier in the record. Do you have one? If not, you can create a running sum in a report or VBA code but without an "anchor", you won't be able to do it in a query. A Running sum sums all the records "before" this one. In order to get the records in a specific order and keep them there, you need something unique on which to sort. Both a report and a VBA loop can work on physical order which may or may not produce the results you are looking for.