Query Syntax Error

  • Thread starter Thread starter Chip
  • Start date Start date
C

Chip

Hey everyone, I keep getting an error in this query that says Syntax
Error in JOIN operation. Does anyone see what I dont see here?

SELECT tblStudents.ID, [tblStudents]![Lastname] & ", " & [tblStudents]!
[Firstname] AS Expr1, tblStudents.CourseNum, [qryAEDPR
Latest].LastOfPRDate, [qryAEDPR Latest].LastOfOutcome, [qryBLSPR
Latest].LastOfPRDate, [qryBLSPR Latest].LastOfOutcome, [qryTRAPR
Latest].LastOfPRDate, [qryTRAPR Latest].LastOfOutcome, [qryMEDPR
Latest].LastOfPRDate, [qryMEDPR Latest].LastOfOutcome
FROM ((((tblCourses INNER JOIN tblStudents ON
tblCourses.ID=tblStudents.CourseNum) LEFT JOIN [qryAEDPR Latest] ON
tblStudents.ID=[qryAEDPR Latest].Student) LEFT JOIN [qryMEDPR Latest]
ON tblStudents.ID=[qryMEDPR Latest].Student) LEFT JOIN qryBLSPR ON
tblStudents.ID=[qryBLSPR Latest].Student) LEFT JOIN [qryTRAPR Latest]
ON tblStudents.ID=[qryTRAPR Latest].Student
WHERE (((tblStudents.Eligibility)=3 Or (tblStudents.Eligibility)=4))
GROUP BY tblStudents.ID, [tblStudents]![Lastname] & ", " &
[tblStudents]![Firstname], tblStudents.CourseNum, [qryAEDPR
Latest].LastOfPRDate, [qryAEDPR Latest].LastOfOutcome, [qryBLSPR
Latest].LastOfPRDate, [qryBLSPR Latest].LastOfOutcome, [qryTRAPR
Latest].LastOfPRDate, [qryTRAPR Latest].LastOfOutcome, ]qryMEDPR
Latest].LastOfPRDate, ]qryMEDPR Latest].LastOfOutcome;

Before i tr and explain what it is i"m trying to do, was interested to
see if this jumps off the page for anyone..

chip
 
On Thu, 12 Nov 2009 04:12:26 -0800 (PST), Chip

The FROM clause start with an open-parenthesis, but does not end with
a close-parenthesis.

-Tom.
Microsoft Access MVP
 
Back
Top