Problem with SQL

[Wong]

Hello there

I have a problem when I try to open a report from to text boxes. It comes up with the Error 3079 which relates to the SQL.

I have attached the sql that show's in the query, can anyone point in the right direction as to what is the problem:
SELECT tblSchoolActivities.[Activity Date], tblSchoolDetails.[School Name], tblSchoolActivities.ActivityTitle, qryTotalPrice1.SumOfPrice, qryTotalKeystage1.SumOfNumberOfPupils, qryTotalWorkshop.[CountOfNo of Workshops], tblSchoolActivities.SchoolContactName, tblSchoolDetails.ADDRESS1, tblSchoolDetails.ADDRESS2, tblSchoolDetails.ADDRESS3, tblSchoolDetails.POSTCODE, Min(tblSchoolActivities.StartTime) AS MinOfStartTime, qryTotalKeystage1.FirstOfKeystage
FROM (((tblSchoolDetails INNER JOIN tblSchoolActivities ON tblSchoolDetails.ID=tblSchoolActivities.[School ID]) INNER JOIN qryTotalWorkshop ON tblSchoolActivities.[ID Activity]=qryTotalWorkshop.[ID Activity]) INNER JOIN qryTotalPrice1 ON tblSchoolActivities.[ID Activity]=qryTotalPrice1.[ID Activity]) INNER JOIN qryTotalKeystage1 ON tblSchoolActivities.[ID Activity]=qryTotalKeystage1.[ID Activity]
GROUP BY tblSchoolActivities.[Activity Date], tblSchoolDetails.[School Name], tblSchoolActivities.ActivityTitle, qryTotalPrice1.SumOfPrice, qryTotalKeystage1.SumOfNumberOfPupils, qryTotalWorkshop.[CountOfNo of Workshops], tblSchoolActivities.SchoolContactName, tblSchoolDetails.ADDRESS1, tblSchoolDetails.ADDRESS2, tblSchoolDetails.ADDRESS3, tblSchoolDetails.POSTCODE, qryTotalKeystage1.FirstOfKeystage
HAVING (((tblSchoolActivities.ActivityTitle)="Starlab"))
ORDER BY tblSchoolActivities.[Activity Date] DESC;

Thank You
Only new to SQL

 

[KenHigg]

I am not even going to try to debug this sql statement but if I may offer a bit of advice; I you ever hope to understand how complex sql statements work, then you may want to consider evaluating them in a more readable format like the one below:

SELECT 		tblSchoolActivities.[Activity Date],
 		tblSchoolDetails.[School Name],
		tblSchoolActivities.ActivityTitle,
		qryTotalPrice1.SumOfPrice, 
		qryTotalKeystage1.SumOfNumberOfPupils, 
		qryTotalWorkshop.[CountOfNo of Workshops], 
		tblSchoolActivities.SchoolContactName, 
		tblSchoolDetails.ADDRESS1, 
		tblSchoolDetails.ADDRESS2, 
		tblSchoolDetails.ADDRESS3, 
		tblSchoolDetails.POSTCODE, 
		Min(tblSchoolActivities.StartTime) AS MinOfStartTime,
		qryTotalKeystage1.FirstOfKeystage 
FROM 	(((tblSchoolDetails 
		INNER JOIN tblSchoolActivities ON tblSchoolDetails.ID=tblSchoolActivities.[School ID]) 
		INNER JOIN qryTotalWorkshop ON tblSchoolActivities.[ID Activity]=qryTotalWorkshop.[ID Activity]) 
		INNER JOIN qryTotalPrice1 ON tblSchoolActivities.[ID Activity]=qryTotalPrice1.[ID Activity]) 
		INNER JOIN qryTotalKeystage1 ON tblSchoolActivities.[ID Activity]=qryTotalKeystage1.[ID Activity]
GROUP BY 
	tblSchoolActivities.[Activity Date],
	tblSchoolDetails.[School Name],
	tblSchoolActivities.ActivityTitle,
	qryTotalPrice1.SumOfPrice,
	qryTotalKeystage1.SumOfNumberOfPupils,
	qryTotalWorkshop.[CountOfNo of Workshops],
	tblSchoolActivities.SchoolContactName,
	tblSchoolDetails.ADDRESS1,
	tblSchoolDetails.ADDRESS2,
	tblSchoolDetails.ADDRESS3,
	tblSchoolDetails.POSTCODE,
	qryTotalKeystage1.FirstOfKeystage
HAVING	(((tblSchoolActivities.ActivityTitle)="Starlab"))
ORDER BY tblSchoolActivities.[Activity Date] DESC;

 

[supercharge]

Hello there
SELECT tblSchoolActivities.[Activity Date], tblSchoolDetails.[School Name], tblSchoolActivities.ActivityTitle, qryTotalPrice1.SumOfPrice, qryTotalKeystage1.SumOfNumberOfPupils, qryTotalWorkshop.[CountOfNo of Workshops], tblSchoolActivities.SchoolContactName, tblSchoolDetails.ADDRESS1, tblSchoolDetails.ADDRESS2, tblSchoolDetails.ADDRESS3, tblSchoolDetails.POSTCODE, Min(tblSchoolActivities.StartTime) AS MinOfStartTime, qryTotalKeystage1.FirstOfKeystage
FROM (((tblSchoolDetails INNER JOIN tblSchoolActivities ON tblSchoolDetails.ID=tblSchoolActivities.[School ID]) INNER JOIN qryTotalWorkshop ON tblSchoolActivities.[ID Activity]=qryTotalWorkshop.[ID Activity]) INNER JOIN qryTotalPrice1 ON tblSchoolActivities.[ID Activity]=qryTotalPrice1.[ID Activity]) INNER JOIN qryTotalKeystage1 ON tblSchoolActivities.[ID Activity]=qryTotalKeystage1.[ID Activity]
GROUP BY tblSchoolActivities.[Activity Date], tblSchoolDetails.[School Name], tblSchoolActivities.ActivityTitle, qryTotalPrice1.SumOfPrice, qryTotalKeystage1.SumOfNumberOfPupils, qryTotalWorkshop.[CountOfNo of Workshops], tblSchoolActivities.SchoolContactName, tblSchoolDetails.ADDRESS1, tblSchoolDetails.ADDRESS2, tblSchoolDetails.ADDRESS3, tblSchoolDetails.POSTCODE, qryTotalKeystage1.FirstOfKeystage
HAVING (((tblSchoolActivities.ActivityTitle)="Starlab"))
ORDER BY tblSchoolActivities.[Activity Date] DESC;

Agree 100% with Ken. Reading this gave me a headache, it's like going thru a maze.