Query Assistance, Please

[cstimart]

I'm not getting my Query to workhttp://www.access-programmers.co.uk/forums/showthread.php?t=216214# right, please help.

I'm using 3 Fields [Book Yr], [Costs], and [Name]...what I'm looking to get is a breakdown/Group by Book Yr of the Count of Name and the Sum of Costs where [Costs] > 0.

I am able to group by the year and and get the correct sum of costs, but the Count of Name includes ALL the records (regardless of Costs).

 

[jackd]

Please post your latest query.

How about

SELECT Count(cstimart.Name) AS CountOfName
, Sum(cstimart.Cost) AS SumOfCost
, cstimart.Yr
FROM cstimart
GROUP BY cstimart.Yr
HAVING Sum(cstimart.Cost)>0

 

[cstimart]

Please post your latest query.

SELECT [Book Yr], Count([Name]), Sum([Costs])
FROM [tblName]
GROUP BY [Book Yr]
HAVING [Book Yr]>=2003 AND Sum([Costs])>0
ORDER BY [Book Yr];

I finally figured it out.

I had to add and addition criteria of

WHERE [Costs]>0