Search results

Thanks Pat I have tried a few different ways but get error msg's SELECT * ,NTILE(4) OVER(ORDER BY [qry_4].[MyCost] DESC) AS Quartile FROM qry_4 My syntax must be off.:(:(:(

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...