Trying to get an Group By clause to work

<i><b>Originally posted by : Terry (rathbun@usa.net)</b></i><br />Hello,<br />Im running this Access query on my asp page:<br /><br />SELECT Dispatch.TechID, Units.RepairUnit,Dispatch.RepCompleteDate, [Units]![RepCompleteTime]*24-[Units]![RepStartTime]*24 AS IHPU, [Repair Unit].RBenchMark FROM Dispatch INNER JOIN ([Repair Unit] INNER JOIN Units ON ([Repair Unit].RepairUnit = Units.RepairUnit) AND ([Repair Unit].RepairUnit = Units.RepairUnit)) ON Dispatch.WorkOrder = Units.WorkOrder ORDER BY Dispatch.TechID, Units.RepairUnit<br /><br />Ive tried to do a Group By clause but it bombs on the page, any suggestions on how i can get this work?<br /><br />Thanks <br />Terry

<i><b>Originally posted by : moz (jgraham@wilcom.com.au)</b></i><br />Not sure what your query is trying to do but to get a group by to work you need to include all the columns in your select clause in your group by statement.<br /><br /><br />------------<br />Terry at 1/17/2001 9:45:58 AM<br /><br />Hello,<br />Im running this Access query on my asp page:<br /><br />SELECT Dispatch.TechID, Units.RepairUnit,Dispatch.RepCompleteDate, [Units]![RepCompleteTime]*24-[Units]![RepStartTime]*24 AS IHPU, [Repair Unit].RBenchMark FROM Dispatch INNER JOIN ([Repair Unit] INNER JOIN Units ON ([Repair Unit].RepairUnit = Units.RepairUnit) AND ([Repair Unit].RepairUnit = Units.RepairUnit)) ON Dispatch.WorkOrder = Units.WorkOrder ORDER BY Dispatch.TechID, Units.RepairUnit<br /><br />Ive tried to do a Group By clause but it bombs on the page, any suggestions on how i can get this work?<br /><br />Thanks <br />Terry