I'm relatively niave regarding things Access. I have a form with a calculated date field that draws its source date from another field in the same table as the calculated field + a certain number of months (taken from a field in another table). I used the formula supplied by MS Access's help system:
=DateSerial(Year(tClasses_Person!LastTaken),Month(tClasses_Person!LastTaken)+ [tClassInfo]![CertLength] ,Day(tClasses_Person!LastTaken))
However, it yields the '#Name?' error. All the table/field names are correct (I got them from the Expression Builder lists.) What am I doing wrong?
Edited by: lodestone on Tue Nov 15 18:41:44 EST 2005.