Automatic Numeric Problem

[solty89]

Hi everyone,
I'm new into doing queries for MS Access and I don't have an idea how to program the following issue.


So for example I have quantity of products into column A.They are sorted good, but i need to give automatic number (into column B) per every product, depend on the sorting as follow:
A.... B
1.... 1
1.... 2
3.... 3,4,5
1.... 6
2.... 7,8
1.... 9
So I can do that in Excel, becouse i can say whats in the previous cell, but i dont know how to doit in Access.

[rpeare]

are you looking to do a running sum (i.e. at the end of item 3 your running total would be 5) or do you actually need to see the value 3, 4, 5 as discrete values?

[solty89]

are you looking to do a running sum (i.e. at the end of item 3 your running total would be 5) or do you actually need to see the value 3, 4, 5 as discrete values?

Yeah, if i get 5 iun the end its still really good, but i dont know how.Any suggestions?

[rpeare]

If you are looking at producing a report there is a running sum feature you can use that doesn't require anything special. If you are looking to produce a running sum on a form that's a little more difficult and would require you to show your data in the same order every single time for the formula to work. If you're looking to produce the running sum in a query the methodology is close to the same as doing it on a form but may be slightly more efficient. If you want the discrete values to show (3 4 and 5 for your third item) that is another problem entirely and would likely require some VBA code. So which is your application of this?

Running sum to be displayed on a report?
Running sum to be displayed in a query/form (keep in mind if the end result is a report even if you don't need to perform the running sum in a query)
or
Running sum AND show discrete values?