On 2008 Nov 14, at 14:46, Peter Kilcoyne wrote:
I have many, but some can't be changed because they used fields that require a calc to activate. But thanks for the input.
One thing you might try is the old technique of dividing stuff into 2 piles and seeing which pile still contains the problem, then repeating with that pile until you've narrowed the problem down to a single item.
In this case, that would be something like duplicating your current layout into 2 clones, throwing away the top half of one and the bottom half of the other, then going to each of the clones in turn to do whatever it is that sets off the problem. Chances are one of the clones will run just fine, while the other will continue to hang you up. It's the latter that you should concentrate on, repeating as needed until you're down to the thing that will not die.
In my experience, the main source of really long calculations is having a string of relationships, in which Table A refers to Table B, which refers to Table C, which refers to Table D, which may refer back to Table A, which refers to Table E, etc. It's all that cross- referencing and recalculating which makes everything run slowly. And the problem is REALLY exacerbated if there's a Sum or Average function operating anywhere.
