Search results

Sorry to drive you mad, i am new to this site and cant remember how i posted this thread but want to post another. Please advise how to. Thanks

Thanks very much for all your help, got it going now. Ta

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

Many thanks for your help, will try it later. Ta

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

Thanks a lot, Just a lot of updates i need and don't feel like clogging my DB with loads of Queries if poss. 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...