Append Query - Student Attendance

[Daryl2106]

Hi,



I am trying to create a way of recording biweekly attendance for multiple faculty and their several classes of 10 or more students. I was trying to follow an example I found online where the faculty could enter the data through a form and then run an append query (AppendAttendnceQuery) that would take the info (BiweeklyDate, ClassesAttended, ClassesOffered) from the form (StudentAttendanceByFacultyQF) and append it to a historical table (StudentAttendance). Currently when I run the query I am getting 0 records appended or the entire 851 rather than only those associated with that faculty selected on the form. I recognize that there are probably lots of problems with the design of this DB. I am hoping to work to correct these once or at the same time as I get the attendance function working. This is a priority for me right now. My knowledge of code is limited. I hope you can help. DB attached.

Thanks and take care,

Daryl

[Daryl2106]

Ooops! Wrong file attached in original post.

[orange]

Some of us don't have acc2010 and can not open your accdb.
You should show us your tables and relationships.
You might want to post the SQL of the append query.
You could show us the article you're working from.
However, until someone with 2010, or you provide more info, any poster would just be guessing.

[Daryl2106]

Hi,

Thanks for the reply. Here is the SQL of the query.

INSERT INTO StudentAttendance ( StudentID, StudentClassID, CourseName, AttendancePeriod, ClassesAttended, ClassesOffered )
SELECT StudentEnrollmentTable.StudentNumber, StudentEnrollmentTable.ProgressKey, CourseInventory.[Course Title], [Forms]![StudentAttendanceByFacultyQF]![Combo1147] AS AP, [Forms]![StudentAttendanceByFacultyQF]![ClassesAttended] AS CA, [Forms]![StudentAttendanceByFacultyQF]![ClassesOffered] AS CO
FROM CourseInventory INNER JOIN StudentEnrollmentTable ON CourseInventory.[ClassNbr 2011 (Term 1119)] = StudentEnrollmentTable.ClassNumber
WHERE ((([Forms]![StudentAttendanceByFacultyQF]![ClassesAttended]) Is Not Null) AND (([Forms]![StudentAttendanceByFacultyQF]![ClassesOffered]) Is Not Null));

I have also attached a screen shot of the relationships and saved the DB as an .mdb file (if it works to do that).

Take care,

Daryl

[orange]

Your database is in accdb format.

Please see the free data model here
http://www.databaseanswers.org/data_...ters/index.htm

and see how he has handled the student roster and attendance (attended_YN)

[Daryl2106]

Thanks,

The link was very helpful!

Take care,

Daryl