I have a form that is a subform based on query. The problem is that the query need a count to be placed on the subform with a groupby statement. This is the sub-select statement I came up with.

SELECT [tblPartInstance].[PartDateReceived] AS PartDateReceived, [tblPartInstance].[JobID] AS JobID, [tblPartInstance].[PartCost] AS PartCost, [tblPartInstance].[OrderID] AS OrderId, [tblPartInstance].[PartLocation] AS PartLocation, [tblPartInstance].[PartDateExpected] AS PartDateExpected (Select Count[tblPartInstance].[PartInstanceID]) AS PartCount)
FROM tblPartInstance;