使用查询创建新查询 [英] Using Queries to create a new query

问题描述

您好，

我一直在使用2个查询来创建查询，但收到一条错误消息，Access无法识别
o.student 当我运行查询时

I have been using 2 queries to create a query but I get an error message that Access cannot recognise o.student when I run the query

QryGetFullName

SELECT IIf((select distinct count(acclass) from studentclass i where i.student = o.student and ( stuyear = year(now()) or stuyear = year (now())-1 ) group by acclass)=2,surname & " " & Chr(174) & " " & firstname,surname & " " & firstname) AS Fullname, StudentIndexes.stuindex AS Ind, o.student, StudentClass.acClass, StudentClass.SubClass, o.NameToPic, o.DateLeft FROM Student AS o INNER JOIN (StudentClass INNER JOIN StudentIndexes ON (StudentClass.Student = StudentIndexes.Student) AND (StudentClass.StuYear = StudentIndexes.StuYear)) ON o.Student = StudentIndexes.Student WHERE (((StudentClass.StuYear)=Year(Now())));

推荐答案

请发布第三个查询导致错误。

Please post the third query that caused the error.

这篇关于使用查询创建新查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！