replace all query

[munday63]

Hi, i have a table of data, with a user name, and a task.

Each user is assigned many tasks, i and i would like to create a query that replaces all instances of a certain name with another name. How would i do that?

Thanks

Sean

 

[rainman89]

Update query!!! criteria would be Where fieldname= name you want replaced