So would it look like this?

SELECT picks.name AS Name, Count(picks.name) AS [Days Picked], Avg(picks.gain) AS [Week 1 Avg Gain]

FROM picks

WHERE (((picks.entrydate)>=#1/3/2005#) AND ((picks.entrydate)=#1/10/2005#) AND ((picks.entrydate)<=#1/14/2005#))

GROUP BY picks.name

ORDER BY Avg(picks.gain) DESC;

Thnaks...