Validation Rule Violation

J

Joe Gieder

I created an update query and after it runs I get a
validation rules violation error and nothing updates.
What type of error is this? I looked at the structure of
both tables and they appear to be the same.
The query syntax is:

UPDATE [MarchMay404 Plant Locs] INNER JOIN MARCMAY404 ON
[MarchMay404 Plant Locs].Material = MARCMAY404.Material
SET [MarchMay404 Plant Locs].AC01 = IIf([marcmay404]!
[plant]="AC01","X","");

How can I make this work? I've been trying for hours and
to no evale.

TIA
Joe
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Update Query 1
show all records in a join 1
Help With Parameter Query 2
Help! Outer Join problem 6
Update Query and Format issues 2
UPDATE QUERY 2
Enter Parameter Value Message Pops Up 4
How do I filter a report to show only specific date 3

Top