Hello All,
I have a report that has 2 text boxes containing numbers based from a table, a third text with an if funtion, =IIF([text1]=0,"NA",[text1]/[text2]), this box is meant to be a percent of box 1 and 2. When I run the report I get the #NAME? error, I go into design view and all the control sources and names are correctly spelled, non-circular, and non-conflicting. I make any change at all to either the if formula or the name of the text box, save and problem solved, so i think. I then close the database, re-open it and there it is again, #NAME?, starting to drive me crazy, everythime i fix it, it comes back as soon as I close and re-open. ANY thoughts?
Thanks in advance