#name error on dlookup field in MS Access report
Posted on 2012-09-13
I have a DLOOKUP function on a field in a MS Access report that is returning a #NAME? error. The syntax for the function is:
The "Change" value is calculated as: ([FY1213]-[FY1112])/[FY1112] and is noted as an expressions whereas the FY1112 and FY1213 values are Summed. So, in the query, you have:
FY112 - Sum
FY1213 - Sum
Change - Expression
Can someone explain to me why this is not working? I have DSUM functions in the same report and they are working quite well.