Conditional Criteria in an Append Querie?

[BKZwaan]

Hi All,
I am appending a table to another table that has two similar columns:

Part ID and Part #

If the Part ID cell is blank, I want to add the Part #. Is this possible in an append querie or do I need to perform additional queries?

Thanks

 

[CharlesChuckieCharles]

Yes that would be an update query

 

[HiTechCoach]

This may be what you need:

ACC2000: How to Update and Append Records in One Update Query