Append Query destination Criteria

[armyofdux]

Is there a way to specify a condition for an append query to copy.

For example, I have the two tables I want to copy records from/to by use of a yes/no column.

I also have a yes/no column on my destination table. I want the record that has a Yes checkmark to copy the already specified/selected fields based on the destination table's also single Yes check mark.

This is what I have:


Yes And [Student Data]![ReadyForCrsRes]=Yes

[armyofdux]

Now that I think a little more this might be better suited as a update query.