Numerazione

[sergran]

Hello everyone, I need your help.
I have a series of columns, where in some specific columns are duplicate data.
I could use that might have been identified individual duplicates and numbered differently depending on the group in which they are
Here's an example
The databse is formed by
_Colonna "Brand"
_Colonna "Model"
_Colonna "Version"
_Colonna "Freon"
_Colonna "Oil"

record 1) Audi -> A4 -> 2000 TDi -> 500 -> 300
records 2) Audi -> A6 -> 2000 TDi -> 500 -> 300
record 3) BMW -> Z1 -> 3000 TDi -> 450 -> 200
record 4) BMW -> X5 -> 2500 TDI -> 350 -> 150

The data control dupplicati must only be in column Freo and Oil


In the example above, the result should be

record 1) Audi -> A4 -> 2000 TDi -> 500 -> 300 ---------- -> 0001
records 2) Audi -> A6 -> 2000 TDi -> 500 -> 300 ---------- ---> 0001
record 3) BMW -> Z1 -> 3000 TDi -> 450 -> 200 ---------- -> 0002
record 4) BMW -> X5 -> 2500 TDI -> 350 -> 150 ---------- -> 0003
And 'possible to get such a thing?
Thank you very much

[June7]

Ranking or row number is common topic in forum. Doing this in query and/or form is not easy. Review http://allenbrowne.com/ranking.html

However, textbox in report has a RunningSum property which can be used to sequentially number records by group.

None of these techniques will save the sequence to table.

Automatically generating an identifier and saving into table requires code that looks up the last saved value and then increments. Review https://www.accessforums.net/forms/a...ing-23329.html