ascending value in update query

[MartijnR]

hi,

is it possible to make an update query which sets a long field in a table to a certain base-number+ascendingvalue?

the basenumber part I have of the query allready works, but now the ascending part.

I was thinking of something like the recordnumber in the recordset to use for this value. I just don't know how

Anyone?

 

[MartijnR]

anybody?

 

[MartijnR]

let me explain what I want.

there are about 2000 products, each with a unique code. these products are divided into categories. what I want is to assign a new code to each product in a specific category.

first thing that needs to be done is to clear the present codes. this I have working.

second thing is to re-code the products. this works, but not completely. I can assign the basecode to a range product, but the field is unique, so I need to increase the new code with 1.

there must be a simple command to do this (I hope), so I can make the update query do the reassigning (basenr+increasing value).

hopefully I explained it, since this is all part of a db and I don't want to redesign the db. however, the solution you gave sounds promising, but to 'omslachtig' (don't know the english word for it now, but it means to do a lot of work which can be done a lot easier).