QBW Update Query

[lez]

Hi Guys,

Just a quick question, in the query design window, how can I update a list
of number to +1 from the final number in the list

TIA
Lez

 

[Lynn Trapp]

That depends on what you mean by "the final number."

 

[lez]

I mean the last number I have in my sequence i.e. my last number item is
1700 I have 250+ records I want to update so the records would be 1701,
1702, 1703 etc.

HTH

Lez