Complicated Expression?? Please help!

[Just1]

I have created a basic client contact database, and dependent upon whether the client is classed as say, as a decision maker, or as an influencer will affect when they should next be contacted. I have attempted an expression in my Date of Next Contact Field using my Classification field, and Date Last Contacted field. If there is no date in the date last contacted field, I just want the current date returned.

Please note I have never typed expressions in Access before, only Excel !! This probably explains why this isn't working!!!!. It says "the expression you entered contains invalid syntax (you may have entered an operand without an operator)". Can any expert tell me what I've done wrong??? Don't tell me, it's simple.....?! Here goes:

=IIf([Classification]="Decision Maker" And iif(IsNull[Date Last Contacted], Date(), iif([Classification]"Decision Maker"
And iif(IsNotNull[Date Last Contacted], [Date Last Contacted]+30,” ”))))

When I can get this to work, I want to add to the expression for different classifications.

Many Thanks

 

[IfButOnly]

Try
=IIf([Classification]="Decision Maker" And IsNull[Date Last Contacted], Date(), iif([Classification]"Decision Maker"
And IsNotNull[Date Last Contacted], [Date Last Contacted]+30,” ”))

peter

 

[Just1]

Thanks for help, but I have tried this and it still won't work and comes up with same error message. Perhaps I'm missing something really obvious?....