Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

A Report: Calculation on two total text boxes

Status
Not open for further replies.

jeffcravener

Technical User
Apr 10, 2003
37
US
I have a query that has a field called ResponseTime. I use that as the grouping in a report. There are 2 possible values: <30, <2 Business Days.

In the ResponseTime Header I put a text ox that calculates the total records for each group.

On the report header I want to add a text box that calcuates the percentage of each to the total records.

How can I do this? Thanks!!
 
Use the total calculation from the header in the report footer.

Then simply add another text box in the header and divide your original calculation by the report footer calculation. Set format type as Percent.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top