Hi
I am new to this forum and would be pleased if you could advise why the following query will not give me the correct result.
"SELECT tblMember.MemFirstName, tblMember.MemSurname, IIf(IsNull([tblMember]![MemDOB])," No Record",Year(Now()-[tblMember]![MemDOB])) AS Age
FROM tblMember;
Thanking...