hey everyone, i need some quick help if anyone has time. i need to create a procedure that will go through a table and change all values that meet a criteria (ie. if a value is "N/A" then change it to "99"). does anyone know any good vba procedures for this? or can the actual access db this on close or something?

thanks in advance