I have a form that is set to Continuous forms view. In the footer section, I have 6 text fields with their control source as "=Sum([amount1])" (for example). Amount1 to Amount6 are fields in the detail section.

The table being displayed is very small, like 3 - 6 records. These "Sum" fields are not displaying for a very long time...minutes. It took me awhile to notice that the word "calculating... " was...