Update Query

[zmbaker]

How do I make an update query that will update a yes/no field for a specified list of serial numbers?

[lfpm062010]

I don't think it is possible. A yes/no field can only store 0 and -1.
You have to change the data type to number or text.

[zmbaker]

I dont think you are understanding my question based on your reply. What I am asking is that i have a list of serial numbers and I need to update the related yes/no field with each of those serial numbers.

[orange]

@zmbaker,

Is your question:

How do I update the serial numbers for records that have Yes in a Yes/No field?

[lfpm062010]

I am sorry that I misunderstood your question.

To select the Yes in Yes/No field the criteria is "Yes" or -1.
To select the No in Yes/No field the criteria is "No" or 0.