Unchecking the tick boxes in the table

[ranj.bassi]

Hi

was wondering if i could get some assistance to hopefully a simple query.

In one of my tables i have about 1000 records with the data type yes/no and the problem is I have reliased that I need to have as a default value a yes (or a tick in my form) but i dont want to go down each record filling in a tick. Is there any easier way to do this

You will have to bear with me I am pretty new to access.

I manage to set up a default value of yes but this will only work on new records entered, but the issue i have is I require it to be on my records which are already there.

Any help will be really appreciated.

Thanks

Ranj

 

[ghudson]

Use an Update query to set the value of that field to a Yes for all records in the table. The actual value is really a -1 [negative one] for Yes/True and a 0 [zero] of No/False. You could use the criteria of that field in the update query and test if it is not a -1 and then update the field to a -1 if needed.