Yes/No Checkboxes

[Marbles]

I have two databases, which at the end of the year, I archive the records into a table; "Previous Years". Since most people in the databases personal details rarely change, the only things I normally have to change are Prices and some Checkboxes ( from yes to no). Find and Replace is easy with Prices, but I can't get it to work with Checkboxes. Am I doing it wrong, or is there a less labourious way than unticking one by one?

Thank you

 

[Norie]

You could try an update query.

By the way why are you 'archiving' the data.

Why not just add a field that indicates the year?

 

[petejm]

Could you use an update query to change the records of the yes/no boxes from -1 (yes) to 0 (No)

Pete

 

[Marbles]

I'll try the Update Query.

 

[Marbles]

The Update Qyuery works Fine. Thank you.

I have a Field for the Year which I use Find and Replace on after archiving the records. I am trying to start the year with all with details that are going to change back to the start. Hopefully with one or two macro buttons to archive and replace, someone else can then take care of the records and mostly the database.

Thanks again