Update query problem - Urgent

[AccessuserDHL]

Hi,

I have an indexed table (unique autonumber) in Access. I have in this table an other column with every X rows a number (X varies) and the rest of the rows below are empty. This situation repeats again with another number and again all the fields under it are empty. Is there a possibility to run an update query to update all fields below to that certain number? Can you define a range (by using a range in the autonumber) to update all the fields in that range to that specific number ??

PLEASE HELP!!

Thanks!!!

Cheers,

 

[edtab]

Yes, you can use an autonumber field in your update query criteria.
If I understand you situation correctly, you will have to open your table and determine the last number and the ID's of the records you want to update with that number.