DateAdd expression

[drklaasen]

Hello,


I am an amateur when it comes to programming and I would appreciate some help with the following.
I need to calculate the next date for screening from the last screening date using an interval.
The fields are: LatestScreenDate, RecallFrequence (=integer) and NextMammoDueDate.
I tried the expression: NextMammoDueDateateAdd("yyyy", [LatestScreenDate],[RecallFrequence]) but that gives an error about wrong parenthesis.
I suspect that I am doing something laughable but I can't work it out.
I am using MSAccess 2007.

Thanks.
I can't get rid of that smiley Read: D colon

[Micron]

the useage is interval, amount, date. You have it the other way around.