Re: Unbound Formula required urgently please

"deaconj999" <deaconj999@xxxxxxxxxxxxxx> wrote in message
news:1174247216.001602.268860@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
On Mar 18, 7:35 pm, "Rick Brandt" <rickbran...@xxxxxxxxxxx> wrote:
"deaconj999" <deaconj...@xxxxxxxxxxxxxx> wrote in message
Your first two DateAdd() functions don't have a closing parenthesis.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Maybe, but I have no idea where they go to be honest

The syntax for DateAdd() is..

DateAdd("interval", number, Date to add to)

The closing parenthesis therefore go immediately after the date you are adding
to.

=IIf([Risk Factor]="High - Annual",DateAdd("yyyy",1,[Date of Last
FSMP]), IIf([Risk Factor]="Med - 3 Yearly",DateAdd("yyyy",3,[Date of
Last FSMP]), IIf([Risk Factor]="Low - 5 Yearly",DateAdd("yyyy",5,[Date
of Last FSMP]))))


--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com


.

Relevant Pages