Thanks nico5038...I managed to come right with the increment function. :-) kcludick1001

My query result looks like this
StockCode Description Supplier SupCatalogueNum
020-01250-0120016 Sht MS CR 2.5x1.2mx1.6mm ALE003 10018500
020-01250-0120016 Sht MS CR 2.5x1.2mx1.6mm NJR001
020-01250-0120016 Sht MS CR 2.5x1.2mx1.6mm STA002 RCR2450122516
020-01250-0120016...

I have a query with the following fields: StockCode, Description, Supplier, SupCatalogueNum .
A stockcode can be purchased from more than one supplier. How do I number the suppliers from 1 to 5 on the same stock code

Exp: StockCode: 020-01250-0120016
Supplier: ALE003
Supplier: NJR001
Supplier: STA002

I need to add colum with Supplier No:
Supplier No
ALE003 1
NJR001...