Access 2007 / update query

[Abay]

Hello .. I am trying to create a query to update a field with a sequential
number (not starting at 1) on certain conditions, by adding 1 to a value in
a table which contains the updated sequential no. I would like to do this
for each record in the query.

My question .. how do I update the table containing the latest sequential
number after each record is processed. I can update the sequential number
(in the data table) to the value in the sequential no table, but the same
number is placed in the data table for all records .. i.e. I add 1 to the
current number, but can't see how I can update it for each new record.

I hope this makes sense.

Any help is much appreciated.

Abay

 

[Abay]

Hello again .. I seem to have figured it out ... I update the table at the
same time as I am updating the data field.

Another question ... I am new to Access 2007, being used to the 2003
version. Am no expert, but muddle through, I can't spend as much time using
Access as I would wish.

The ribbon in 2007 is very confusing at the moment, hopefully it will get to
be automatic ... one problem is the way
for example Query names are displayed ... not totally alphabetically .. this
is a real pain as I have a lot of Queries (also forms) ... not very
efficient to have to keep scrolling down to find the appropriate one.

Is there a way to dictate the sequence of the display.

Again, any help would be most appreciated.

Thanks
Abay