L
Laurel
When I try to specify child and master link fields in the source for a chart
(which is embedded in a form), I get this error.
"The specified field, qryLevelsAll.Student_ID could refer to more than one
table listed in the From clause of your SQL statement."
The child field is [qryLevelsAll.Student_id] (I've also tried
[qryLevelsAll].[Student_ID].
The row source for the chart is:
SELECT qryLevelsAll.Week_of, Avg(qryLevelsAll.Level) AS AvgOfLevel FROM
qryLevelsAll GROUP BY qryLevelsAll.Week_of ORDER BY qryLevelsAll.Week_of;
The SQL for the query qryLevelsAll is:
SELECT [first_name] & " " & [last_name] AS Full_Name,
fncWeekStartDate([level_date]) AS Week_of, tblStudents.Student_ID,
tblStudents.Class_Code,
fncLevelAsNumber([tblLevels.Student_ID],[Level_Date]) AS [Level],
tblLevels.*
FROM tblStudents INNER JOIN tblLevels ON tblStudents.Student_ID =
tblLevels.Student_ID
ORDER BY [first_name] & " " & [last_name], fncWeekStartDate([level_date])
DESC;
(which is embedded in a form), I get this error.
"The specified field, qryLevelsAll.Student_ID could refer to more than one
table listed in the From clause of your SQL statement."
The child field is [qryLevelsAll.Student_id] (I've also tried
[qryLevelsAll].[Student_ID].
The row source for the chart is:
SELECT qryLevelsAll.Week_of, Avg(qryLevelsAll.Level) AS AvgOfLevel FROM
qryLevelsAll GROUP BY qryLevelsAll.Week_of ORDER BY qryLevelsAll.Week_of;
The SQL for the query qryLevelsAll is:
SELECT [first_name] & " " & [last_name] AS Full_Name,
fncWeekStartDate([level_date]) AS Week_of, tblStudents.Student_ID,
tblStudents.Class_Code,
fncLevelAsNumber([tblLevels.Student_ID],[Level_Date]) AS [Level],
tblLevels.*
FROM tblStudents INNER JOIN tblLevels ON tblStudents.Student_ID =
tblLevels.Student_ID
ORDER BY [first_name] & " " & [last_name], fncWeekStartDate([level_date])
DESC;