Counting number of records from a table

[puthenveetil]

Hi all,

Is there any option to count the number or records relating to
a specific field. Here is the details..The db is for a school and there is a tables for
class and students. I am using a form to enter students details. I had created a
relationship with these two tables. i am using a query to get the details regarding a specific
class like classname, class teacher like that.. Is there any way to calculate the number of students in that specific class.

now i am using the query as follows

SELECT Class.*
FROM Class
WHERE (((Class.ClassID)=[Forms]![Class]![ClassID]));

I had created the relationship with the above two tables with classid as the primary key


thanks in advance

Thanks

 

[maxmangion]

create a total query and use the count function in the Total row of your query.

 

[puthenveetil]

create a total query and use the count function in the Total row of your query.

thanks max,

can u please tell me how to do that...


thanks

 

[maxmangion]

in your query click on the Σ to make the Total row visible, then click on the drop down arrow (on your total row) of the field in question and select count.

 

[puthenveetil]

in your query click on the Σ to make the Total row visible, then click on the drop down arrow (on your total row) of the field in question and select count.

hi max,

thanks for the reply...you are life saver


Thanks

 

[maxmangion]

you're welcome