Why does Access ask for parameter value when I enter criteria for a calculated field?
Posted on 2011-04-20
In Access 2007, I have a column that calculates an eligibility date from a previous field and it works like a dream. Here is the syntax for that code:
When I enter criteria in this column, <[DATE]
I get asked for a Parameter Value for the the HIRE parameter. The Hire parameter is it's own calculation and works when I don't put in the criteria.
Here is a succession of the columns:
HIRE: CDate(IIf(Len([MBHIRE])=7,Format(Mid([MBHIRE],4,2) & "-" & Mid([MBHIRE],6,2) & "-" & Mid([MBHIRE],2,2),"mm\/dd\/yyyy"),Format(Mid([MBHIRE],3,2) & "-" & Mid([MBHIRE],5,2) & "-" & Left([MBHIRE],2),"mm\/dd\/yyyy"))) *** Represents one column
ELIG: DateAdd("m",12,[HIRE]) *** Represents the column next to it.
Any help would be greatly appreciated.