M
Michal
Hi all,
I have a large table that contains, amongst other things, client ID and
sales data for each sale for each client, something like:
ID1 $150
ID1 $200
ID1 $100
ID1 $250
ID2 $100
ID2 $200 etc
How can I create a query to show 3rd quartile for each client ID? In Excel
it’s very easy as there is a built-in QUARTILE function
(QUARTILE(array,quart)) but I don’t seem to be able to find a similar option
in Access.
Thanks in advance.
I have a large table that contains, amongst other things, client ID and
sales data for each sale for each client, something like:
ID1 $150
ID1 $200
ID1 $100
ID1 $250
ID2 $100
ID2 $200 etc
How can I create a query to show 3rd quartile for each client ID? In Excel
it’s very easy as there is a built-in QUARTILE function
(QUARTILE(array,quart)) but I don’t seem to be able to find a similar option
in Access.
Thanks in advance.