Hi,
Can anyone tell me why this is not updating the table?
UPDATE FMPSL SET MODE_PREM = ([2010]/12)
WHERE (((DatePart("m",(DateAdd("m",1,Date()))))=DatePart("m",[FMPSL].[REG_DATE])) AND (([MODE])="M"));
Thanks.
Can anyone tell me why this is not updating the table?
UPDATE FMPSL SET MODE_PREM = ([2010]/12)
WHERE (((DatePart("m",(DateAdd("m",1,Date()))))=DatePart("m",[FMPSL].[REG_DATE])) AND (([MODE])="M"));
Thanks.