Update multi records

[xaysana]

Hi there,

How can i update name column for multi records where id = SA001 - SA010 in range?
What i like to happen is:

id name
SA001 insert Tony
........ ...............
........ ...............
........ ...............
SA010 insert Tony

any help will appriciate please?
Thank you in advance

 

[John Big Booty]

You should be able to do it with an Update Query using the criteria;

>= "SA001" And <= "SA010"

for id, or

Between "SA001" And "SA010"