Search results

Thanks for the responses so far. Can anyone answer the question above?

I'm rubbish at Access so how would I create an Autonumber field for each code1 i.e. For Code1=1, autonumber from 1 to 3000, Code1=2, autonumber from 1 to 3000 etc?

Joining Code1 & Code2 together (e.g. Code1_Code2) would be a unique identifier. Should I create a field with this identifier and call it PKID and use the code above?

Thanks Brian. I need to find the top 5% values so have to take account of all 150 values when calculating the average. The only way i can think of is to sort and then add an index from 1 to 3000 for each code1 - can that only be done by using vba code?

I tried this code and it's not giving the correct answers. I think this is due to the fact that reserve, for the most part, has a value of zero so the RANK function won't be able to deal with this. In an example file with 3000 lines Reserve was non-zero for only 62 of these lines. Anyone have...

Thanks for the reply Brian - I'll give your code a try in work tomorrow.

Hi...first time poster so be gentle :cool: I have a table in the following format: Code1 Code2 Reserve 1 5 678 1 9 23 ...... Code1 takes values from 1 to 945 and Code2 takes values from 1 to 3000 (the table has 945*3,000=2,835,000 lines) I need to summarise by Code1 for the average of...