If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
#Name? error in calculated Controls
Hi - I'm having a difficult time figuring out why I am getting the
error #Name? in all calculated fields on my report. I have verified that the name of the control is not used in the expression and that there are no erroneous spaces in my expression. The expressions I'm using vary from iif statements to basic arithmetic of two other fields e.g. =[Reimbursement]+[Ineligible] and =IIf([claims]0,IIf([Total_claims]-[ded]0,[Total_claims]-[ded]- ([Total_claims]-[ded]-[claims]),0),0) What may be causing these errors? Thanks |
#2
|
|||
|
|||
#Name? error in calculated Controls
David
When I receive the "#Name?" in a control, Access is telling me that it can't find something with the name I told it. Usually, this happens because I typed in the name of a field or other control, rather than copying and pasting the name. In other words, "typos"! Regards Jeff Boyce Microsoft Office/Access MVP "David H" wrote in message ups.com... Hi - I'm having a difficult time figuring out why I am getting the error #Name? in all calculated fields on my report. I have verified that the name of the control is not used in the expression and that there are no erroneous spaces in my expression. The expressions I'm using vary from iif statements to basic arithmetic of two other fields e.g. =[Reimbursement]+[Ineligible] and =IIf([claims]0,IIf([Total_claims]-[ded]0,[Total_claims]-[ded]- ([Total_claims]-[ded]-[claims]),0),0) What may be causing these errors? Thanks |
Thread Tools | |
Display Modes | |
|
|