Clear data in a complete yes/no column

[Hartkoorn]

K,

I'm new here and I have a question:
In my db I have a yes/no tick, now I want to create a button that clears out all the ticks in that specific column, possible?
To clarify:
I have an address db with an gift table (tbl_gift) and a yes/no parameter for, lets say, 'did they gave me a present with christmas?' (col_gift).
Naturally I want to clear their records before next christmas, now instead of going through all the records and remove the tick, is there a fast-one-button-click solution for this?

Thanks in advance!
Paul
(btw: sorry for my English, I'm Dutch and damn proud of it!)

 

[*Pete*]

Hi, You will need an update query based on your table, so when run it will change all of your yes values to no, you can then attach this to a button on your form.

 

[RV]

(btw: sorry for my English, I'm Dutch and damn proud of it!)

Actually, your English is quite good, as is quite common for Dutchies
BTW, there is an excellent forum in Dutch that deals with Access, Excel, Word, to mention a few.
Check it out :

http://office.webforums.nl/forum/index.php

RV (also proud to be Dutch )

 

[Hartkoorn]

Ta for the fast reply guys!!
Getting up and running again.

Paul
(btw: sorry for my English, I'm Dutch and damn proud of it!)