I have a MS Access data base with a table named Orders I need to find all records with
status(Field in Table)"OPEN" after I find them I then need to change "OPEN" to "ORDERED" Can any one give me help on this?

Thanks