Sum(amount1) taking a very long time to calculate

[Ruth Coleman]

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 shown in the bottom left corner. Although the screen was not locked, I could make changes to data.

Has anyone else run into this? Does anyone have any ideas on how to make these calculated fields display faster?

[sierra7]

Hi
I've set up a test database to check this out. I was interested to see whether having/ or not having a Primary Key on the table had any effect. However, both versions add 6 x 6 'instantly'. (6 values over 6 records)

Is there any code in your form that Access is choosing to run first rather than doing 'housekeeping' and calculating the sums?
S7

[NeoPa]

As S7 says, this is unusual and unexpected behaviour. I'll leave you in his capables for now, but clearly there's something else importantly different about your database or setup that hasn't been included in the question.