how to change some data in a table?

[Gustavson]

I'm using access 97.

I have a field in a table which contain many different hazard classes of specific chemicals.

Is there a way to change all the equivalent data in the field of a table?

For example, one of my hazard classes is h. toxic which stands for highly toxic. I have a few hundred of these h.toxic entries and I want them all to be converted to highly toxic. Instead of going through and changing each individually, is there a way I can change all of these at once?

Hope this makes sense..
Thanx
Gustavson

 

[PPSAG]

Use an update query with a where condition. Update the field to highly toxic where it currently equals h.toxic. I don't know if you use design view or SQL so I won't give you the code, but an update query will do what you want, I did something similiar to one of my chemical databases recently. Good luck
Mooo...