I have a form with unbound textboxes that filter out dates and opens a report that shows stores and their total sales. The report is grouped by date and sorted by store number. When I input a textbox in the "Date" group footer for total sales that day, it does not calculate the sum of sales for that day. The control source is set to "Total Sales" field. Please help.