Here's an easy one I'm sure. I'm going cross-eyed looking at it. I use the following SQL to pull a record using 2 criteria. The recordset opens fine using everything except the "Answers.Race = 'White' portion. With the entire statement I get the Syntex Error (Missing Operator) error the portion of the statement starting with "Having Answers.aTopic" is included in the message.
Thanks for the fresh look.
strSQL = "SELECT Answers.aTopic, Answers.Race, Sum(" & strTest & ")/ " & intNoWhite & " AS SumOfAnswer2 " _
& "From Answers GROUP BY Answers.aTopic, Answers.Race " _
& "Having Answers.aTopic = " & cboSubject1 & " AND Answers.Race = 'White'
Thanks for the fresh look.
strSQL = "SELECT Answers.aTopic, Answers.Race, Sum(" & strTest & ")/ " & intNoWhite & " AS SumOfAnswer2 " _
& "From Answers GROUP BY Answers.aTopic, Answers.Race " _
& "Having Answers.aTopic = " & cboSubject1 & " AND Answers.Race = 'White'