Will this work?

[g0009348]

Could you please advise if this will work? I;m not sure a And and OR is correct?

WHERE (((pt_tbl.SS_Status)=False) AND ((PartInformation.PendingObsolescenceDate)<>#31/12/9999#)) OR ((D20_EFF_IN_Y)=(servicereleasedate));

Thanks

 

[Norie]

What, in words, criteria do you want to apply?

As it is it looks like it's this, return records where either,

pt_tbl.SS_Status =False AND PendingObsolescenceDate<>#31/12/9999#

is true, or,

D20_EFF_IN_Y=servicereleasedate

is true.

Is that what you want?

 

[g0009348]

UPDATE pt_tbl INNER JOIN PartInformation ON pt_tbl.WERS = PartInformation.EngineeringPartNumber SET pt_tbl.SS_Status = True
WHERE (((pt_tbl.SS_Status)=False) AND ((PartInformation.PendingObsolescenceDate)<>#31/12/9999#)) OR ((D20_EFF_IN_Y)=(servicereleasedate));

Hi, This is the full statement.

I need it to set the SS_Status to true, but only where the ss status is already false and PartInformation.PendingObsolescenceDate is not equal to 31/12/9999 or the D20_EFF_IN_Y date matches the servicereleasedate

 

[Norie]

Is this what you mean?

Update records where,

pt_tbl.SS_Status =False

AND

PendingObsolescenceDate<>#31/12/9999# Or

D20_EFF_IN_Y=servicereleasedate

 

[g0009348]

yes, exactly that, however I've tried the code but it didnt update any parts affected by the OR D20_EFF_IN_Y=servicereleasedate

 

[Norie]

Does this work?

UPDATE pt_tbl INNER JOIN PartInformation ON pt_tbl.WERS = PartInformation.EngineeringPartNumber SET pt_tbl.SS_Status = True
WHERE pt_tbl.SS_Status=False AND (PartInformation.PendingObsolescenceDate<>#31/12/9999# OR D20_EFF_IN_Y=servicereleasedate);

 

[g0009348]

No, still returns the same result as if the OR D20_EFF_IN_Y=servicereleasedate) statement wasnt there. It is dates in both these colums, would that make any difference?

 

[Micron]

If any of these are table/field references,

D20_EFF_IN_Y=servicereleasedate

I would try adding the table name same as is done elsewhere: pt_tbl.SS_Status
The fact that the table isn't referenced leads me to think this is a sql statement in code, as I suspect Access would otherwise automatically include it.
So, as long as there are dates in D20_EFF_IN_Y that equals what looks like a variable reference, it should work - provided that servicereleasedate is formatted properly.
If it is a variable that equals (for example) 21/05/2015, it will not work if you have not included the date delimiters. How you'd solve this depends on whether or not this is sql being executed in vba or a query.