Summary Fields (Total of)

[mattc]

I have a call logging database & I need to pull out some reporting information. I have numerous calculation fields that:

Get(Curentdate) -1

-2

-3

-4

Etc

I then have further fields where:

if(logdate) = ;1,0)

A summary field then gives the total of each calculation field giving me call numbers per day. The only problem I have is that the more summary fields I add, the slower the calculation time is (as I have 2000 + calls in which it's summerising).

I need to get these figures idealy without performing finds/scripting.

Is there a better way?

Sorry if i've missed an obvious one.

[Søren Dyhr]

Well I came to think of this ...it reuses the same index as well as summary field ...however are the fields likely to "hang", and in order to freshen first place the cursor inside the fields and the then click outside.

I have solved with, yikes... "a script" that hardly would overwhelm too many souls!

--sd

testSummary.zip

[Søren Dyhr]

I found a bug in my previous upload, let me suggest this instead:

--sd

testSummar2.zip

[mattc]

Thanks for the reply.

In the end I have found that the best way is to filter the records prior to entering a layout containing summary fields. By only having a couple of hundred records to summarize rather than a couple of thousands, I have no speed issues.

Makes sense I suppose.

Cheers