Append Query - Student Placements (1 Viewer)

MvdBergh

New member
Local time
Yesterday, 18:55
Joined
Apr 9, 2012
Messages
5
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?
 

Attachments

  • Stud_Placements - Copy.accdb
    1.3 MB · Views: 30
Last edited:

JHB

Have been here a while
Local time
Today, 02:55
Joined
Jun 17, 2012
Messages
7,732
The below query should do it:
Code:
INSERT INTO tblPlacements ( Student, Intake )
SELECT tblPlacements.Student, [Forms]![frmMenu]![cboPlacementto] AS Intake
FROM tblPlacements
WHERE (((tblPlacements.Intake)=[Forms]![frmMenu]![cboPlacementFrom]));
 

MvdBergh

New member
Local time
Yesterday, 18:55
Joined
Apr 9, 2012
Messages
5
JHB, you are super!!!!! Thanks a million. My problem is solved.
 

JHB

Have been here a while
Local time
Today, 02:55
Joined
Jun 17, 2012
Messages
7,732
You're welcome - good luck. :)
 

Users who are viewing this thread

Top Bottom