Re: Unbound Formula required urgently please

On Mar 18, 7:35 pm, "Rick Brandt" <rickbran...@xxxxxxxxxxx> wrote:
"deaconj999" <deaconj...@xxxxxxxxxxxxxx> wrote in message

news:1174246313.437516.147550@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

Rick,

=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]))))

I still get the invalid syntax error "you may have entered an operand
without an operator"

This must be a typo in the formulae perhaps obviously I am trying to
add the value 1 3 or 5 years from the [ to the date entered in [Date
of Last FSMP]

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

.

Relevant Pages

  • Re: DateAdd Function
    ... Rick Brandt, Microsoft Access MVP ... RBrandt at Hunter dot com ...
    (microsoft.public.access.forms)
  • Re: Force a save
    ... Rick Brandt, Microsoft Access MVP ... RBrandt at Hunter dot com ...
    (microsoft.public.access.modulesdaovba)
  • Re: Emails from Access
    ... Bald Eagle ... References. ... Rick Brandt, Microsoft Access MVP ...
    (microsoft.public.access.modulesdaovba)
  • Re: Query stops working with ODBC to SQL Server. Help!
    ... Rick Brandt, Microsoft Access MVP ... RBrandt at Hunter dot com ... have SQL Server DataTypes that do not map exactly to Access/Jet DataTypes. ...
    (comp.databases.ms-access)
  • Re: user/password problem
    ... so the administrators can change the ... If VBA code could read a person's password that would make the password ... Rick Brandt, Microsoft Access MVP ...
    (microsoft.public.access.formscoding)