How do I total an unbound control in a report? The criteria for the control cannot be moved to a query. I have written code to zero a total field when the report is open, add to the total field on Detail_format, and move the total to the report at reportfooter_format. But the total amount is way off.