I am trying to calculate percentile using a MS Access query.
and I am trying to use a Access query that calls a function.
For example, I have a table and with field A, B, and C. I need to first group the table by A and B, then within each group I need to calculate percentile for C.
I understand I can write a function using VBA but then the function works only for the whole column of C. The function would need input of table name, field name, and percentile. Can anybody please show me how to apply the function for each group (by A and B) instead of just the whole field?
Please help. Thanks a lot!