I am learning as I go here but i just cant figure this one out
I have table listing Insect Broods. there are two fields I am working with and they are [Seed Date] and [POP Est]
I am strying to sum all records within 1 week date ranges to provide available populations
I created the following query
SELECT Sum(Broods.[POP Est]) AS [SumOfPOP Est], Broods.[Seed Date], Broods.[Brood ID], Broods.Species
FROM Broods
GROUP BY Broods.[Seed Date], Broods.[Brood ID], Broods.Species
HAVING (([Seed Date]>=DateAdd("d",-17,Date())) AND ((Broods.Species)='House Cricket'));
That is to give me a sum of all crickets from 17 days after seed
I intend to furthur filter this down to only sum the populations from 10 days to 17 days but baby steps here i cant get past this first one
Problem is instead of totaling the values contained in [POP Est] it is displaying all the records.
Can someone see what i am doing wrong
thanks in advance