Studio Crash on SQL query

[Balestrieri, John]

The enclosed SELECT is crashing Valentina Studio on my database (valentina unexpectedly quits). If I omit the column Results.FocusParty there's no crash. Results.FocusPart is a calculation field:  if(party='GOP' or party='Dem',party,'Other')

Performing a SELECT on just Results.FocusParty is fine... no crash, and the correct results are being returned. Not performing any aggregate functions/grouping is also OK -- no crash. I'm going to run this query in Rb and see what happens now...

John

------

SELECT
	Race.CountyName,
    	Results.FocusParty,
        Sum(Results.VoteCount) AS 'VoteTally',
        Sum(Race.PrecinctsReporting) AS 'PrecinctTally',
        Sum(Race.TotalPrecincts) AS 'PrecinctTotal'

FROM	
        Results,
        Race
       
WHERE
        Race.RaceCountyID = Results.RaceCountyID
    	AND Results.Meta_State = 'CA' --State postal
    	AND Race.OfficeID = 'G' --Office

    	
GROUP BY
	Race.CountyName,
	Results.FocusParty
   	
ORDER BY
	Race.CountyName,
        VoteTally DESC


The information contained in this communication is intended for the use of the designated recipients named above. If the reader of this communication is not the intended recipient, you are hereby notified that you have received this communication in error, and that any review, dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify The Associated Press immediately by telephone at +1-212-621-1898 and delete this email. Thank you.