Update Query

  • Thread starter Thread starter Roger Bell
  • Start date Start date
R

Roger Bell

I have the following code in an update query:

UPDATE [MAIN TABLE] SET [MAIN TABLE].[WWC CARD REGISTERED1] = No, [MAIN
TABLE].[WWC CARD REGISTERED2] = No
WHERE ((([MAIN TABLE].[VALID TO1])<Now())) OR ((([MAIN TABLE].[VALID
TO2])<Now()));

The problem is that when this query is executed, it updates both fields to
NO, whether the Card has expired or not.

Is there a way around this?

I appreciate any help for a novice and Thanks
 
Have you considered using IIF statement?
UPDATE [MAIN TABLE] SET ([MAIN TABLE].[WWC CARD REGISTERED1] = IIF([MAIN
TABLE].[VALID TO1]<Now(), No, [MAIN TABLE].[WWC CARD REGISTERED1])), ([MAIN
TABLE].[WWC CARD REGISTERED2] = IIF([MAIN TABLE].[VALID TO2]<Now(), No, [MAIN
TABLE].[WWC CARD REGISTERED2]));
 
Back
Top