Speeding up calculations

[Lemur]

Hello,

I'm working on finalizing my database -- I've come a long way!

Regrettably, the wall I've recently hit is a pretty big one. A lot of my calculations in one file take AGONIZINGLY long to compute. I even tried to store them, but I'm unable to do so.

I have the entire file zipped up and posted here -- if you check it out, look at the file called "Players" - and then, check out the layout copy #1 -- the time to refresh the screen is horrible.

If anyone can help - please email me at [email protected] - I look forward to any suggestions that can be made to speed up the calculations.

Thanks!

Chris

My_Progress.zip

[Lemur]

Figured it out...

By changing the fields from "calculations" to either text or number, with an auto-entered calculation, I could manually force the field to be indexed - yes, it's slightly bigger, but the calculations are immediate, it seems...

They're not dynamic calculations now - but, I don't know that they necessarily need to be...I'll have to do some more testing; but I'm happy with the speed, currently...

Chris