Query/Table fields based off value of another field.

[MPXJohn]

Same error.

[Bulzie]

I just tested this again and it works. I created 2 tables with the field you had in your attachment and when I run this in a query window, it updates the ItemDes with AssemblyName when it finds records based on the Like statement. If you can test putting data in the field, take out the Like command and put in a specific value such as WHERE (((ProductionData_Main.ItemName) = "006-2024-1.0 REV 5")); If that works then it is something with the Like part.


UPDATE ASSEMBLY, ProductionData_Main SET ProductionData_Main.ItemDes = [ASSEMBLY].[AssemblyName]
WHERE (((ProductionData_Main.ItemName) Like "*" & [ASSEMBLY].[AssemblyName] & "*"));

Sorry but if this does not work, I'm out of ideas. Maybe someone else can resolve or see what the problem is.

[MPXJohn]

Thanks Bulzie. Can you clarify one thing though. You keep saying 2 TABLES. But remember, I discovered I have to use one table & one query. Will that make a difference?

[Bulzie]

Possibly, can you run that query to get records and manually change a value to see if it lets you.

[MPXJohn]

So I created a table from my query so I was working with 2 tables. Here is what is in SQL sheet:

UPDATE ASSEMBLY, ProductionTable
SET ProductionTable.ItemDes = [ASSEMBLY].[AssemblyDescription]
WHERE (((ProductionTable.ItemName) Like "*" & [ASSEMBLY].[AssemblyName] & "*"));

I had to change some names. I have also attached the design view of the query. This may be our last straw.