I am working on a simple concept database that has as aim to place enrolled students to the next year’s intake. (See attached db)
There are three tables:
1. tblStudent
StudID (Autonumber)
StudName (Short Text)
2. tblIntake
IntakeID (AutoNumber)
Intake (Short TexT
3. tblPlacements
ID (AutoNumber)
Student (Number from tblStudent)
Intake (Number from tblIntake)
· I thought of performing an “Append Query” to update tblPlacements that obtains its criteria from a form (frmMenu) that has two combo boxes linked to tblIntake.
· The first combo box is cboPlacementFrom, and the second cboPlacementTo.
· The idea is to keep the old enrolment data in tblPlacements (ex. “Intake 2” for all students currently enrolled) and copy them them to, for example “Intake 3”, as addisonal records in tblPlacements.
I’m failing with the Append Query. Any ideas shall be highly appreciated?
There are three tables:
1. tblStudent
StudID (Autonumber)
StudName (Short Text)
2. tblIntake
IntakeID (AutoNumber)
Intake (Short TexT
3. tblPlacements
ID (AutoNumber)
Student (Number from tblStudent)
Intake (Number from tblIntake)
· I thought of performing an “Append Query” to update tblPlacements that obtains its criteria from a form (frmMenu) that has two combo boxes linked to tblIntake.
· The first combo box is cboPlacementFrom, and the second cboPlacementTo.
· The idea is to keep the old enrolment data in tblPlacements (ex. “Intake 2” for all students currently enrolled) and copy them them to, for example “Intake 3”, as addisonal records in tblPlacements.
I’m failing with the Append Query. Any ideas shall be highly appreciated?
Attachments
Last edited: