Sorry to bother, not sure what im doing wrong, tried that script in a query (SQL view) got error "invalid sql statement, expected delete, insert, update..". tried a few changes and not getting anywhere.
Thanks
Doesnt let me do multiple updates in 1 query! Want to make a run button (Save) so that the user can run the update and not drive me mad every time!!!
ta
I have a db called "OUTY"
in it a table called "Students"
in the table a field called "class"
I want to make an update query to update
where class = '5' update to '6'
where class = '4' update to '5'
where class = '3' update to '4'
.......
Ive tried all codes posted and cant get around...