Count number of records

[Andy]

I need to be able to count the number people who are registered in a
certain IT course. i need to display the results on a form or report.

This is for my A level courswork please help!

thanks

[Steve Jorgensen]

On 23 Jan 2004 08:10:15 -0800, an*********@hotmail.com (Andy) wrote:

I need to be able to count the number people who are registered in a
certain IT course. i need to display the results on a form or report.

This is for my A level courswork please help!

thanks

Am I to understand this is for your computer homework? Have you thought of
looking in the manual, the help system, and/or the example databases?

[Mike Storr]

These are rather general requirements, one could only provide a general
answer.
Create a new query, add the fields you wnat to include such as Name and
Course.
Turn on Totals by choosing "Totals" from the View Menu.
In the bottom of the query window, choose Count in the Totals line of the
Name Field, and leave Group By in the Course Field.
If you leave it at that and run the query, you will return a Count of names
for each course in the table (only one record line for each course). If you
only want a specific course, specify it in the Criteria lines of the query
design grid.
Save the query and close it.

Use the Form Wizard to create the desired style of form, basing it on the
query you just created.
Done.

Mike Storr
www.veraccess.com


"Andy" <an*********@hotmail.com> wrote in message
news:a7**************************@posting.google.c om...

I need to be able to count the number people who are registered in a
certain IT course. i need to display the results on a form or report.

This is for my A level courswork please help!

thanks