Hello,
I want to ask if it is possible to total the number of rows with the same data in the specified field.
Let's say that we have students A, B, C and D. There are ability levels 1, 2 and 3. The table shows:
Student Ability
A 1
B 1
C 2
D 3
and now we want to know how many students have ability 1, 2 and 3.
I want to do it in a query and then run a report on it or by sing the module.
I know we can create a query for each ability level and then set for example ability ="3". But is there any shorter way of solving it? Because at the present I have about 10 different ability levels and I have to include them in my database.
Thanks,
matt
I want to ask if it is possible to total the number of rows with the same data in the specified field.
Let's say that we have students A, B, C and D. There are ability levels 1, 2 and 3. The table shows:
Student Ability
A 1
B 1
C 2
D 3
and now we want to know how many students have ability 1, 2 and 3.
I want to do it in a query and then run a report on it or by sing the module.
I know we can create a query for each ability level and then set for example ability ="3". But is there any shorter way of solving it? Because at the present I have about 10 different ability levels and I have to include them in my database.
Thanks,
matt
