C
catherine
Hi, I'm trying to establish a report which shows needed
training. I had help with the SQL but have another
criteria. Unfortunately, the way the database was
previously designed did not include all of the options for
a person's history (tblTraining.Training);a person could
have been trained in Organisms (Training field) but (Kit2
field) says Organisms-2 and the report is pulling that up
as needed training. Is there any way to allow in
tblTraining those kits that may have an extension? The
code so far is as follows:
SELECT tblTeacherClassInfo.TeacherNo,
tblTeacherClassInfo.KitName_2, tblTeacherClassInfo.FName,
tblTeacherClassInfo.LName
FROM tblTeacherClassInfo
LEFT JOIN tblTraining
ON (tblTeacherClassInfo.KitName_2 = tblTraining.Kit)
AND (tblTeacherClassInfo.TeacherNo = tblTraining.TeacherNo)
WHERE (((tblTraining.TeacherNo) Is Null));
Basically, I'm looking for a way for tblTraining.Kit to
accept tblTeacherClassInfo.KitName_2 if it has an
extension on it and therefore not list it in the report.
Thanks so much for any help!
training. I had help with the SQL but have another
criteria. Unfortunately, the way the database was
previously designed did not include all of the options for
a person's history (tblTraining.Training);a person could
have been trained in Organisms (Training field) but (Kit2
field) says Organisms-2 and the report is pulling that up
as needed training. Is there any way to allow in
tblTraining those kits that may have an extension? The
code so far is as follows:
SELECT tblTeacherClassInfo.TeacherNo,
tblTeacherClassInfo.KitName_2, tblTeacherClassInfo.FName,
tblTeacherClassInfo.LName
FROM tblTeacherClassInfo
LEFT JOIN tblTraining
ON (tblTeacherClassInfo.KitName_2 = tblTraining.Kit)
AND (tblTeacherClassInfo.TeacherNo = tblTraining.TeacherNo)
WHERE (((tblTraining.TeacherNo) Is Null));
Basically, I'm looking for a way for tblTraining.Kit to
accept tblTeacherClassInfo.KitName_2 if it has an
extension on it and therefore not list it in the report.
Thanks so much for any help!