Summary Fields speed

[tommypmadison]

Hello,

I have a database with which I log time spent commuting in my car. Each trip is a new record, and I have over 3500 records.

I have a summary field that adds all the times together so that I have a running total at the bottom of my layout.

Each time I put in a new record, there is a noticeable delay in showing the summary total at the bottom of my layout.

Is there a script, or faster way to summarize these totals???

Thanks,

Tom

[bcooney]

I wouldn't have a summary field on a data entry layout, since it will recalc often. Just create another layout for data entry that excludes the summary field.