Query Criteria to exclude data

[vnms2001]

I have two tables: 1. - Monthly Data, 2. - Supplier Setup

Both of these tables have one common field called Supplier Tax ID and a field called Supplier Status. Status is NT-Non Taxable and T-Taxable. Table Monthly Data does not have the field populated with the code NT, but Supplier Setup table does. My question is how can I populate the filed Supplier Status with the code of NT in the Monthly Data table autoamtically? Can I use a Query, or lookup? How can I do it. Please help.

Thank you

[orange]

see this tutorial

[vnms2001]

Thank you so much