Append Query What values do you use to append a Yes into a Yes/No 2

[JC442]

Dear Wonderful Person Who Can Help,

I have to populate an access table that has fields with Yes/No Format. If I want the value to be checked "Yes" what value should be used in the append data query.
Using "Yes", 1, and -1 have not worked. Software is Access 2003.

Thanks,
JC

 

[AlexCuse]

You just use Yes and No (without the quotes).

Hope this helps,

Alex

[small]----signature below----[/small]
Now you can go where the people are one!
Now you can go where they get things done!

 

[JerryKlmns]

... or True

UPDATE myTable
SET myYesNoField = True
WHERE myWhereClause

 

[JC442]

An interesting wrinkle in this problem is that the table designer Used a Yes/No Format and combined it with a validation ="No" Or "Yes". Since Yes/No fields normally hold values of 0 or -1 this may be the problem.

Because of the Validation rule / Format Combination True, or Yes, or "Yes' or 0 or -1 will not work.

I'm going back to the table designer with this one.

Thank you both for you kind input.
Very Best,
JC