Add Category to Category Cell based on Criteria From Product Cell

[sixth_brand]

Hi everyone,

Hopefully this is in the right place. I am using Access 2013 and have been wrecking my brain on this one. I thought all I needed was a simple update query. I have two tables. One is for Products and the other is the Category. These tables are linked via the category field to enforce referential integrity. Every month the data in the Product table will be updated and this can be done via an append query.

Here is the problem. I need the category field within the Product table to update itself into the correct category based on criteria I set. Such as if the product starts with MFT: Make the category Mens Formal Trousers. The category field in the product table is null to start with.

Am I being really silly? Is this possible or achievable perhaps by VBA?

[sixth_brand]

Figured it out. My criteria was set wrong. I was setting it to look for criteria within a range Like "[MFT]*". I needed to change this to
Like MFT*

It now works beautifully.