[RESOLVED] In need of fast help--Access 2003

[dreamdelerium]

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

[mrmojorisin]

Hi,

Do you know much about queries? To solve this problem you could create an update query that updates the field with in your table with '99' where the value is null.

e.g:

UPDATE Table1 SET Table1.Numbe = 99
WHERE (((Table1.Numbe) Is Null));

Let me know if you need more help?
Mojo