#NAME? Error keeps coming back

[tharless]

Ok, I ran the report, went into design view saved the report without changing anything and still get the error.
Here is the documentation of the sub report

[RayMilhon]

Can't believe I didn't notice this yesterday. Change the % in the textboxname to percent.

[tharless]

No change, still goes back to the error everytime I close and re-open

[RayMilhon]

Think I finally figured it out. The format of the textbox is percent. "N/A" is not a Percent it's a string.

Change the format to text

Where you have [MonthSDC]/[MonthCLMTS] Change it to Str(Round([MonthSDC]/[MonthCLMTS]*100,1)) & "%"

That should give you something like 11.1 % Change the ,1) above to however many decimal points you want to show in the %

[tharless]

Still the same result, I even deleted the box all together and took out the if statment and just went [MonthSDC]/[MonthCLMTS], and still get the same error when I close and reopen.

[RayMilhon]

Have you tried opening just the subreport to see what that field looks like? It's possible that the field is fine. The link between the main report and the subreport might have an issue?

[tharless]

Yeah I tried that and still get the same result

[RayMilhon]

Try one more thing. Go into the design of the subreport go to the recordsouce I'm assuming it's a query. Just run the query Take a look at the values of those 2 fields. Make sure they're both numeric. If they are then I've got no clue.

[tharless]

This is a mystery I will probably never figure out and at this point I don't care anymore. But you are a genious good sir, I checked the control source and it turns out that it wasn't running from a query, it was runing from a table. So I created a simple query on the table, did the calculation in the query using the, Str(Round([MonthSDC]/[MonthCLMTS]*100,1)) & "%", formula you provided and just used that for the text box's control source instead of using the formula in the report. We may never why it kept erroring out but at least I got it working now. Thank you so much for all your help.

[RayMilhon]

Glad I could help.