Update all records at once

[The_Doc_Man]

Dear Sir
Iam here to learn , I'm not a expert like you .. so keep calm when you advice me or anyone else..
Thanks for your kind efforts

Please do not mistake my response's intention. I try to not sugar-coat what I say, I just tell you what I see. And I cannot tell whether you have had trouble describing your problem because of language issues or because you are not very familiar with what Access does. If my direct approach is not pleasing to you, I am sorry. But I try to avoid making too many assumptions. I have found that the more assumptions I make, the more often I end up confusing people.

I can explain a lot of things but until I know which direction an explanation must go, it is hard for me to correctly respond. At the moment I am unsure of what you specifically need to know.

 

[James Dickinson]

To update all records at once then remove the where condition. It will still update 1 record at a time however as that's just how access works.
The where condition is limiting the "who". So any where condition will filter your table and reduce your quantity of records effected.