Query: Agregate Function Error

[psycoperl]

Hi All , I have the following query and I am receiving the following error: "You tried to execute a query that does not include the specified expression 'qryRPT_FullRoster_Status_TestDate.[ATBMet?]="Yes" as part of an aggregate function.

I am unable to see where the problem is nor how to solve this... can you please provide guidance

SELECT [qryRPT_FullRoster_Status_TestDate].[StuLastName] & ", " & [qryRPT_FullRoster_Status_TestDate].[StuFirstName] AS [Report Name], 
  qryMaxReading.TestDate AS [RA Date], 
  qryMaxReading.Score AS [RA Score], 
  qryMaxReading.RaMet AS [RA Met], 
  qryMaxWriting.TestDate AS [WO Date], 
  qryMaxWriting.Score AS [WO Score], 
  qryMaxWriting.WoMet AS [WO Met], 
  qryMaxMath.TestDate AS [MA Date], 
  qryMaxMath.M1Score AS [M1 Score], 
  qryMaxMath.MaMet AS [MA Met], 
  qryRPT_FullRoster_Status_TestDate.[ATBMet?], 
  qryRPT_FullRoster_Status_TestDate.SSN4, 
  qryRPT_FullRoster_Status_TestDate.StudentID
FROM 
 ((qryRPT_FullRoster_Status_TestDate LEFT JOIN qryMaxMath ON qryRPT_FullRoster_Status_TestDate.StudentID = qryMaxMath.StudentID) 
    LEFT JOIN qryMaxReading ON qryRPT_FullRoster_Status_TestDate.StudentID = qryMaxReading.StudentID) 
    LEFT JOIN qryMaxWriting ON qryRPT_FullRoster_Status_TestDate.StudentID = qryMaxWriting.StudentID
GROUP BY 
  [qryRPT_FullRoster_Status_TestDate].[StuLastName] & ", " & [qryRPT_FullRoster_Status_TestDate].[StuFirstName],  
  qryMaxReading.TestDate, 
  qryMaxReading.Score, 
  qryMaxReading.RaMet, 
  qryMaxWriting.TestDate, 
  qryMaxWriting.Score, 
  qryMaxWriting.WoMet, 
  qryMaxMath.TestDate, 
  qryMaxMath.M1Score, 
  qryMaxMath.MaMet, 
  qryRPT_FullRoster_Status_TestDate.[ATBMet?], 
  qryRPT_FullRoster_Status_TestDate.SSN4, 
  qryRPT_FullRoster_Status_TestDate.StudentID, 
  qryRPT_FullRoster_Status_TestDate.StuLastName, 
  qryRPT_FullRoster_Status_TestDate.StuFirstName
HAVING 
  (((qryRPT_FullRoster_Status_TestDate.[ATBMet?])="Yes"))
ORDER BY 
  qryRPT_FullRoster_Status_TestDate.[ATBMet?], 
  qryRPT_FullRoster_Status_TestDate.StuLastName, 
  qryRPT_FullRoster_Status_TestDate.StuFirstName, 
  qryRPT_FullRoster_Status_TestDate.SSN4;

 

[dprante]

I could be wrong, but try replacing your "HAVING" with "WHERE". Does it work?