View Single Post
  #1  
Old May 31st, 2010, 09:34 PM posted to microsoft.public.access
forest8
external usenet poster
 
Posts: 196
Default #Name? error in Formula

Hi there

As I mentioned in the subject line, I am currently getting a @Name? error in
a formula.

The formula I have is

=DateDiff("yyyy",[DateofBirth],Date())-IIf(Format(Date(),"mmdd")Format([DateofBirth],"mmdd"),0,1)

I noticed that the field should be [Date of Birth] but when I try to edit
the formula, the formula change does not stick.

How do I get the formula to stick?

Thank you for your help in advance.