By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
428,829 Members | 1,828 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 428,829 IT Pros & Developers. It's quick & easy.

Count number of records

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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?
Nov 12 '05 #2

P: n/a
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

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.