Update query adding to field values (1 Viewer)

[emartel]

Hi, hope you can help!?!
I have an update query which on a certain date needs to reset order numbers in sequential order. As some clients don't order in each period, I have set 1 update query to set the OrderRef to 1, and want to create another update query which changes the OrderRef to =previous record +1. Therefore, after the 2nd query has run, all current clients will have their own number between 1and the number of current clients.

How can I get an update query to add 1 to the prev record?

many thanks!!

 

[emartel]

Alright then, I guess that that was impossible!

Can anyone suggest how I could generate a new number starting at 1 for current (as opposed to expired) clients, not related to the Invoice number or the Client number, which can be reset at the touch of a button?

many thanks

 

[gblack]

Hmm

I'm not sure I understand what it is that you want.

If you have an update query with a record field (lets call it [field1]), Why can't you just put [field1] + 1 in the update section of the query?

This would add 1 to every record in the query... Or am I missing something?