update fields on query (1 Viewer)

[hessleroader]

i have a query that show me all records that have not been invoice so there is a field from the order that have a value of invoiced="no"

so what i want to do is when i have printed these records i want to change the records field invoiced to "yes" any ideas

at the minute i have to go into the query and use the replace funtion on the menu bar. "no" replace with "yes" which is not any good.

any ideas
please

 

[neileg]

Use an update query.

 

[ratbags21]

why don't you run an update query for just that field :-
update to "Yes" where Invoiced = "no"

 

[hessleroader]

thanks worked a treat!