Populate column based on data in another column

[afinch03]

I am trying to find a way to populate a column based on the data in another column. I think it should be pretty easy, just don't know where to start.



Here is essentially what I need:

If column A = X, Y, or Z, populate (or update) column B with "M". If column A = U,V, or W, populate (or update) column B with "N."

I assume I can do this with a query, but if there is some other functionality within Access that would be better, I would be willing to use that.

[orange]

Since this is your first post ---welcome!

Can you tell readers in a few lines WHAT you are trying to do? Plain English ---there may be some options.

Most applications don't have columns A and B. We often see FirstName, ProductCode, SupplierNUmber etc.

[afinch03]

Current database has a column in the table called Product. Records are populated with product codes (e.g. "V", "S", "U"). I added a column in the table titled Magazine. I would like to populate this column with a value determined by the product code. (If Product = "V", "C", or "Y" populate Magazine with "Vac.")

[orange]

If your table is called Product, then you should not have a field/column called Product. I think this maybe your Product code.
It is best not to have spaces within and Access object names. So, assuming your Product table has fields/columns
ProductCode and Magazine, then you could use a query

SELECT ProductCode, Magazine  from Product
Where ProductCode In("V","C","Y")

This will show which records would be updated.

If this gives you the data you expect, then you could do an Update query

UPDATE Product
SET Magazine = "Vac."
Where  ProductCode In("V","C","Y")