select name,sum(pagecount)
from table1
''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
where getdate between #2003-01-01# and #2004-08-06#
'注意access的时间用的是##不是''表示时间
''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
group by name
楼上的。可以执行的。