我以前做过一个类似的,你参考参考.


<%
action = Request.QueryString("action")
if action = "get_today" then
sql_time = "where datediff(d,f_ip_time,getdate()) = 0 "
elseif action = "get_thisweek" then
sql_time = "where datediff(ww,f_ip_time,getdate()) = 0 "
elseif action = "get_thismonth" then
sql_time = "where datediff(m,f_ip_time,getdate()) = 0 "
elseif action = "get_fromto" then
    if Request.QueryString("start_time") <> "" then
    sql_time = "where f_ip_time between '" & Request.QueryString("start_time") & " 00:00:00' and '" & Request.QueryString("to_date") &" "& FormatDateTime(now(),3) &"' "
    else
    sql_time = "where datediff(d,f_ip_time,'" & Request.QueryString("to_date")& "') = 0 "
    end if
elseif action = "get_iptype" then
sql_time = "where f_ip_type = '" & Request.QueryString("type") & "' "
else
sql_time = ""
end if

set rs=server.CreateObject("Adodb.Recordset")
sql = "select * from tb_ip " &sql_time& "order by f_ip_time desc"
'Response.Write(SQL)
'response.End()
rs.open sql,conn,1,1
%>

大哥，我试了，没想通，请在指点啊！！
显示所有数据后，下面有每日汇总，每周汇总，每月汇总，等
点击相关的汇总就显示出汇总的结果值出来了。
可是这个SQL语句，我怎么写都没实现，着急啊，不是不显示，就是把数据全部汇总了，小弟有理了，帮个忙。
这个SQL语句怎么写？？？？