In need of fast help--Access 2003 (1 Viewer)

[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

 

[twoplustwo]

You could just write an update query for this.

http://www.databasedev.co.uk/update_query.html

 

[dreamdelerium]

genius. thanks it worked like a charm

 

[twoplustwo]

Glad we managed to sort it.

Take it easy.