Validation Rule Violation

  • Thread starter Thread starter Joe Gieder
  • Start date Start date
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
 
Back
Top