Hi - I was wondering if there is a funtion in Access similar to NTILE or if I need to create a custome function for this. Anyway I'm out of idea's.
Basically I would like to calulate top percent of values contained in a cost column of ~15,000 records.
The top 75% of values = A, etc.
IIF([MyUnitCost]=75%,"A","B") if something like this mock up worked I might try a nested if to add "C".
NTILE does not appear to work in Access.
TOP PERCENT seemed to return top 75% of to records, not values.
RANK did not seem to work either.
I probably have overlooked a simple way to do this.
Thanks
Basically I would like to calulate top percent of values contained in a cost column of ~15,000 records.
The top 75% of values = A, etc.
IIF([MyUnitCost]=75%,"A","B") if something like this mock up worked I might try a nested if to add "C".
NTILE does not appear to work in Access.
TOP PERCENT seemed to return top 75% of to records, not values.
RANK did not seem to work either.
I probably have overlooked a simple way to do this.
Thanks