How to get footer calculations

[mmitchell]

I converted a form and its queires from Access MDB to ADP and I can't get my form to show the footer calculations anymore.

The underlying query has two fields that are sumed that I want to do a calculation on.

sum(dbo.vProcMgrTotalFeetPerWOID_ByShift.TotalFeet * dbo.vAvgWtPerFt_Setup_ECN_WOID.AvgWt_Setup_ECN_WOID) as OrderLBSProduced,

SUM(dbo.vProcMgrTotalFeetPerWOID_ByShift.TotalScrpFeet * dbo.vAvgWtPerFt_Setup_ECN_WOID.AvgWt_Setup_ECN_WOID) as OrderLBSScrap

And in the forms footer I had:

Sum([OrderLBSScrap])/Sum([OrderLBSProduced]+[OrderLBSScrap])