Re: Unbound Formula required urgently please

On Mar 18, 8:03 pm, "Rick Brandt" <rickbran...@xxxxxxxxxxx> wrote:
"deaconj999" <deaconj...@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

Rick,

Many thanks, it shows #Name? in the Date of next FSMP box where the
formulae is, any final ideas ?

.

Relevant Pages