Sorry.. I should have read that from the beginning. But, I went and entered the expression into the sorting and grouping box as well, and I got the same error message:
"the expression you entered has a function containing the wrong number of arguments."
Again, I found the problem to be the extra closing bracket was missing. I added the bracket, and received no error message. I added the closing bracket at the end of (Left(prop_num, 2), so the final expression is:
=IIf(CInt(Left(prop_num,2)) >= 30, "19" & prop_num, "20" & prop_num)
comteck
