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.
If not then what is it you really want from that number? You can't put brackets around part of it as it then does not become a number. You can't have the / slash because it is not a number but is an operator.