How to get footer calculations

[mistux]

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

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

sum(dbo.vProcMgrTotalFeetPerWOID_ByShift.TotalFeet
dbo.vAvgWtPerFt_Setup_ECN_WOID.AvgWt_Setup_ECN_WOID) a
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]

 

[Sylvain Lafontaine]

You forgot to write the = at the beginning of your expression.

Also, it will help if you have controls (visible or not) that have
OrderLBSProduced and OrderLBSScrap as their sources (and probably with
OrderLBSProduced and OrderLBSScrap as their names, too) to make sure that
Access can properly reference these fields. This is particularly important
for Reports.

 

[mistux]

Actually i did have the = sign.

It seems you can't sum a sumed field in an ADP like you could in a
MDB. Bummer!