Where Command

[joe31709]

WHERE((DateDiff("y",[test]![CompDate],Now())>=15))


I have put that in the criteria in a query.

I have an update Query setup, If there comp date is less than 15 years then they get so many hours. But when I try to run the query I get Undefined Function Where in expression.

I know someone got an answer

Thank you,

Joe

 

[intern42]

If you're in design view, try taking the "WHERE" out.