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

 

[Guest]

I'm assuming you mean the original value + 1?

Try something like:
Make your query an update query. In the updatefield..

[YourUpdateField]+1

Where yourupdatefield = your field that needs updating. Be sure it's a field
and it's placed between square brackets otherwise all fields will be updated
with the text "YourUpdateField+1". Anyway a backup would be a great thing to
make just before you run this query...

hth