culcuated field for SQL (1 Viewer)

[Tfa]

culcuated sequencial field for SQL

Helloooooo

i have a not so dubious problem but i need some help
I have a that has 2 fields
the first one has letters
the second numbers
that helps with the order by
because the second field can change and leave gaps i want to create a new field tha will be calculated and create this

LGroup Ngroup CGroup
A 1 1
A 2 2
A 5 3
A 8 4
B 1 1
B 2 2
B 8 3



and so on

i am open to suggestion
either woth VBA or SQL i don't mind

 

[Ranman256]

append your data to a premade table with an AUTONUM field.
the order will be created.
Note: if you do this more than once, you will need 2 tables; tResults, and tResultsMT
tResultsMT is a virgin copy of tResults that never gets data in it so it can preserve the autonum field so it can being with '1'.

copy tResultsMT to tResults
append data to tResults (record numbers are created)