Group Footer amount is totaled for all records rather that just for the header

[SAC]

I want a report that looks like this:

Property Name PropSqFt Department AllocatedSqFt PerCentAllocated
========== ======= ======== ========= ============
A 2700 Accounting 257
Whatever 257/2700 is
A 2700 Finance 657

I'd like to Group on Property, but in the group footer, Property Sq Ft is
being summed for each record. I only what it as 2700. Just for it's amount
so I can calulated:

Total Allocated Sq Ft
Total Property Sq Ft
Per Cent Allocated.

Right now I'm getting something like this:

Property Name PropSqFt Department AllocatedSqFt PerCentAllocated
========== ======= ======== ========= ============
Group Header:
A 2700
Accounting 257
Whatever 257/2700 is
Finance 657

Group Footer:
Totals for A 5400 914

I'd like 2700 to be in the group footer so I can use it for the calculation
of what percent is total allocated.

Thanks for your help.

 

[Ken Sheridan]

For the ControlSource properties of the text box's in the group footer do as
follows:

Total Allocated Sq Ft: =Sum([AllocatedSqFt])
Total Property Sq Ft: [PropSqFt]
Per Cent Allocated: =Sum([AllocatedSqFt])/[PropSqFt]

The first simply sums the allocated square footage, the second is bound to
the property square footage field, and the last sums the allocated square
footage and then divides this by the property square footage

Format the last as Percent.

Ken Sheridan
Stafford, England