I have a PO form that has a invoice subform. Within that PO you can have multiple invoices that have materials, labor freight and tax. I'm trying to total all the materials, all the freight, tax and labor and then in the form footer grand total all together. I can't do it in a qry. because if I group it, it shows on the subform that way and I need to see all the individual invoices. Every time I try to do multiple sums within that subform footer I get a #Error. Can someone help.