Hello,
Please can any one help with calculating medians in MS access.
Below is a simplified example of what I want to do
There are four columns as shown:
Column
ID Subjects Criteria Value
1 A yes 2
2 A no 3
3 B yes 4
4 C yes 5
5 A yes 7
6 A no 5
7 B yes 4
8 B yes 5
9 B no 4
10 B no 5
11 B no 5
12 C yes 5
13 C yes 7
14 C no 6
15 C no 7
16 C no 8
I want to run a query that will give the median value per subject
Subject Median value
A ......
B .......
C ........
and also another query that will give the median value if criteria column is yes per subject
ie
Subject Median value if Criteria = yes
A ......
B .......
C .......
similarly I would also want to run another query to get the median value if criteria column is no per subject
ie
Subject Median value if criteria = no
A .......
B .......
C .........
Thanks
Please can any one help with calculating medians in MS access.
Below is a simplified example of what I want to do
There are four columns as shown:
Column
ID Subjects Criteria Value
1 A yes 2
2 A no 3
3 B yes 4
4 C yes 5
5 A yes 7
6 A no 5
7 B yes 4
8 B yes 5
9 B no 4
10 B no 5
11 B no 5
12 C yes 5
13 C yes 7
14 C no 6
15 C no 7
16 C no 8
I want to run a query that will give the median value per subject
Subject Median value
A ......
B .......
C ........
and also another query that will give the median value if criteria column is yes per subject
ie
Subject Median value if Criteria = yes
A ......
B .......
C .......
similarly I would also want to run another query to get the median value if criteria column is no per subject
ie
Subject Median value if criteria = no
A .......
B .......
C .........
Thanks