Thanks for the reply CP. I want to avoid switching to and from excel/access because I want to run >100,00 queries where a rating is calculated and profit/loss stats are calculated looking at the highest rater. Would probably take too long if I had to use both programs.

I could do it now in excel but it would also a long time because my files are so large. I have 6 files about 25Mb each.

A couple of other problems;

I run a query which produces a list of selections with win dividends. I can then run another query on this table to give me:
- no. of selections
- no. of winners
- total of win dividends, etc.
Can I use this query to also calculate the WIN SR and POT? I've worked out how to do it by running another query on the first one but was wondering if it could be done as one.

and

In VBA/excel, I can write code with nested for..next loops to run multiple calculations over and over. Can this be done in Access with a Macro or would I need to use code?

Cheers