Hello Everyone
My question is I have 2 Queries
1. Select Qry (InsGrades)
2. Append Qry (InsGrades1)
ok what i want is to write these sql statements in Vba just for learning purpose How a select statement is declared and after that insert query
regards
My question is I have 2 Queries
1. Select Qry (InsGrades)
SQL:
SELECT SessionYearT.Session_ID, SessionYearT.SessionYear, SessionYearTypeT.SessionYearType_ID, SessionYearTypeT.SessionTypeT, SessionTypeT.SessionType, SessionYearTypeT.StartDate, SessionYearTypeT.EndDate, GradesT.Grade_ID, GradesT.GradeName
FROM (SessionTypeT INNER JOIN GradesT ON SessionTypeT.SessionType_ID = GradesT.SessionType_ID) INNER JOIN (SessionYearT INNER JOIN SessionYearTypeT ON SessionYearT.Session_ID = SessionYearTypeT.SessionYearT) ON SessionTypeT.SessionType_ID = SessionYearTypeT.SessionTypeT
WHERE (((SessionYearTypeT.IsCurrent)=1));
2. Append Qry (InsGrades1)
SQL:
PARAMETERS [Forms]![frmSessionYear]![frmSessionTypesSubform]![txtSessionYearType_ID] Long;
INSERT INTO tblSessionGrades ( SessionYearType_ID, GradeID )
SELECT [Forms]![frmSessionYear]![frmSessionTypesSubform]![txtSessionYearType_ID] AS QSessionYearType_ID, InsGrades.Grade_ID
FROM InsGrades
WHERE (((InsGrades.Session_ID)=1) AND ((InsGrades.SessionTypeT)=1));
ok what i want is to write these sql statements in Vba just for learning purpose How a select statement is declared and after that insert query
regards