COUNT help for a newbie

[mhowle]

I have a flat database with several fields that contain student names and courses enrolled for 10 classes. I need to get a count of the number of students signed up for the courses offered.

Question is, how would I count the number of times that the course numbers in a lookup table (Courses) show up in the fields "Class01" through "Class10" in the "StudentSchedule" table?

I would like to have it in a report view that would be printable.

Remember, I'm a newbie, so please be easy with me

I have read through the help file a number of times and googled everything I know to google but can't get counting multiple fields much less pulling the criteria from a lookup. (or even prompting for it). At least I found this Forum!!!!

TableDetails:
StudentSchedule - StuFirst, StuLast, StuMI, Grade, Class01 through Class10

Courses - CourseNumber

ThanksInAdvance,
mhowle

 

[KeithB13]

Set up a query with the feild(s) you want to count and set the "total" property to "Count". You may have to use the "total: property to "group by". Set up a report based on the query.

I hope this is some help. We were all wet behind the ears at some point.

School Project?

 

[Mile-O]

Your database has one HUGE design flaw: you have repeating groups in a table.

Search on this forum for threads about Normalising databases.


If you want to present data in the way you have it you'd be better off just using Excel.