Divide Sum's on a Report 1

[TJVFree]

I thought this would be a simple formula, but I’ve been out of the loop working on report and forms.

I’m trying to take the review footer totals and divide them by my report totals. What am I missing? Is it because the Report Footer is named the same at the Review Footer?

Thanks for taking the time to help


Review Footer
=Sum([Num of Apps]

Report Footer
=Sum([Num of Apps])

Simple Division
=Sum([Num of Apps]/Sum([Num of Apps])

 

[dhookom]

Are your expressions simple typos or are these actual control sources?

Would you expect this expression to return some value other than 1?

=Sum([Num of Apps])/Sum([Num of Apps])

Duane
Hook'D on Access
MS Access MVP

 

[TJVFree]

Hi Duane,

Maybe I didn’t explain it correctly. I’m trying to divide the = ([review header]/ [report header])


Review Header is the sum of the number of reviews per rep
Report Header is the sum of all reviews

The Formula blow just returns 100%
=Sum([Num of Apps])/Sum([Num of Apps])

 

[dhookom]

Where are you attempting to place the text box with the division?

Do you understand why the text box displays 100%?

You might be able to replace the denominator with the name of the text box from the report footer.

Duane
Hook'D on Access
MS Access MVP

 

[TJVFree]

Totally forgot that we can do that on reports and forms.

Thanks again Duane, you’re always a big help, even with these silly questions

=([Text39]/[Text48]) <-Worked

 

[dhookom]

Text39" and "Text48"? Why not take the two seconds required to rename these controls to something that makes sense? I created a test report prior to replying and changed the name of my control in a report I didn't even save.

Kick your development up a notch and use a good naming convention for all significant controls. I'll be watching your threads in the future so don't make me again.

Duane
Hook'D on Access
MS Access MVP

 

[SkipVought]

Amen!
[sup]From the Amen Corner[/sup]

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]