I have a report, that can have any number of records that will print in the detail section, and a total in the detail footer. Is there any way, to create a field next to each record that will calculate the percentage of that field over the total of all records?

John

__________________
John

Probably yes, but please define percentage. What calculation exactly would you like.

Sal

The value of the each line, divided by the total of all lines.

John

Create a subquery in your data source that calculates the total for all items, then insert an unbound textbox into your report. There you can use the builder to create your calculation field.

As far as your footer question, use a bound textbox with the value in the calculation i just mentioned.
If you were only needing the grand total, it would be easier to just insert an unbound textbox in the footer of the report. This text box would be a copy of the item you would like to sumarize. After you paste it you just add =Sum(FIELDname) (or =Count()).



Sal