I have two tables, one (tblStudentClass) has student IDs and class numbers for what a student will take on Monday, Tuesday, etc to Saturday. The class is a 2 digit number, 01 to 27, formated as text.
The other table (tblInstructor) has the class number (01 to 27) and the instructor name.
I am trying to get a student count for each class by day.
What I have so far is a report using tblInstructor to list the class number,instructor name, then using Dcount to get the number of students taking that class Monday, Tuesday, etc. To do this I have been trying the following in a textbox
=Dcount(Monday,tblStudentClass, Monday=ClassID)
=Dcount(Tuesday,tbleStudentClass, Tuesday=ClassID), etc
each line would have ClassID, Instructor name, number for Monday, Number for Tuesday, etc
I keep gettng an error. What am I doing wrong?
Orlan
__._,_.___
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (1) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar