468,766 Members | 1,523 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,766 developers. It's quick & easy.

Calculating percentage from two subreports on a main report

I have created a main report, which is controlled with a date range parameter from the main form. The report has several sub reports, which perform calculations (counts and averages at the subreport level) based on the date range from the main form. My question or problem is that I have to calculate a percentage based on the result of two of the subreports. I created a text box on the main report and I enterd the following to calculate the percentage on the control source:
=[Reports]![NewToSchedule]![Text7]/( Reports![NewToSchedule]![Text7]+Reports![NewToVoid]![Text11])*100
When I run the main report from the main form I get this #Name?
Could anyone tell me what I am doing wrong.

Thanks in advance
Oct 26 '06 #1
1 2257
14,534 Expert Mod 8TB
Make sure that when you are referencing the subreports, you are using the subreport control name, not the subreport name.

Check the Name property under the other tab in the properties window for the subreports
Oct 27 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by Don Sealer | last post: by
6 posts views Thread by Brett Barry: Go Get Geek! | last post: by
1 post views Thread by CARIGAR | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.