Query Help

[Welthey]

I have the following query and i need to only have files that have aggregate
totals >=5000. If someone could please assist that would be great. Thank
you.


SELECT [03/12-19/01 by date].SSN, Sum(qrySarsAggregateTotal.Aggregate) AS
SumOfAggregate
FROM [03/12-19/01 by date] INNER JOIN qrySarsAggregateTotal ON [03/12-19/01
by date].ID = qrySarsAggregateTotal.ID
GROUP BY [03/12-19/01 by date].SSN
HAVING (((Sum(qrySarsAggregateTotal.Aggregate))>="5000"))
ORDER BY [03/12-19/01 by date].SSN;

 

[Jerry Whittle]

"5000" shouldn't have quotation marks around it. It's a number; not text.

If that doesn't work, try this:

SELECT SSN, SumOfAggregate
FROM (SELECT [03/12-19/01 by date].SSN,
Sum(qrySarsAggregateTotal.Aggregate) AS SumOfAggregate
FROM [03/12-19/01 by date]
INNER JOIN qrySarsAggregateTotal
ON [03/12-19/01 by date].ID = qrySarsAggregateTotal.ID
GROUP BY [03/12-19/01 by date].SSN )
WHERE SumOfAggregate >= 5000
ORDER BY SSN;