[MS_AccessPros] #Name? Error is crazy

 

Hello all,

I have a report that has control with the following expression

=IIf([Total_Budget]=0,0,[APPR_UNCOMMITTED_AMOUNT_$]/[Total_Budget])

When the user runs the report, they get the #Name? error. If I go into the control source and click zoom and then OK, and then run the report the values are shown and correct. It is very frustrating. I have retyped the expression several times and that it does not work.

Thank You for your help

Jim Wagner

__._,_.___

Reply via web post

Reply to sender

Reply to group

Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 5

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use • Send us Feedback

.

__,_._,___