If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
#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. |
#2
|
|||
|
|||
#Name? error in Formula
On Thu, 3 Jun 2010 20:49:02 -0700, forest8
wrote: Hi The Name Autocorrect Options have Track Name Autocorrect Info and Peform name AutoCorrect are checked (i.e. on). That's probably the problem! It's buggy. Tom called it "Name Autocorrupt" - and that's unfortunately an apt nickname. It can remember old deleted names and they can come back like zombies. Try turning Track Name Autocorrect *off*; compact and repair the database; and rename/doublecheck the names of the controls. -- John W. Vinson [MVP] |
Thread Tools | |
Display Modes | |
|
|