After days of trying to create a percentile calculation in access i have decided to ask you for help.
i have a table with the following columns in access
Transaction Date
Days until Returns
User ID
Method
Trans ID
Return Date
ReturnReason
I would like to calculate the percentile for a perticular return reason per month by using the Days until Returns column as the interger.
Is their any adivice or sql you can provide which can help me?
Thanking you in advance.
Sean
i have a table with the following columns in access
Transaction Date
Days until Returns
User ID
Method
Trans ID
Return Date
ReturnReason
I would like to calculate the percentile for a perticular return reason per month by using the Days until Returns column as the interger.
Is their any adivice or sql you can provide which can help me?
Thanking you in advance.
Sean