这个select 语句要怎么写

Set rs=Server.CreateObject("Adodb.RecordSet")

sql="select Pono,Date,Style,Customer,Factory,sum(TotalPrice) as Total_Price from Statistics where Date between #" & FirstDate & "# And #" & EndDate & "# and Factory='"&Factory&"' roup by Date order by id desc"

最后输出"Total_Price "

请要这个语句要怎么改才正确！如何输出显示Total_Price的值

如果你想计算每日的订单总额应该是：

sql="select Date,sum(TotalPrice) as Total_Price from Statistics where Date between #" & FirstDate & "# And #" & EndDate & "# and Factory='"&Factory&"' group by Date order by Date desc"

如果你想要更多新信息:

sql="select Pono,Date,Style,Customer,Factory,sum(TotalPrice) as Total_Price from Statistics where Date between #" & FirstDate & "# And #" & EndDate & "# and Factory='"&Factory&"' group by Pono,Date,Style,Customer,Factory,id order by id desc"

select后非聚集运算Column必须出现在group by后。

• ·长出智齿就代表不能生长了吗？
• ·电脑刚刚重新做的XP程序
• ·天津市有哪些重点中学？请多列一些。
• ·男友是否背叛我?
• ·求4000至4500元台式电脑装机配置...
• ·脑筋急转弯
• ·烦恼啊。关于ISO认证。气体行业谁有经验啊，请
• ·为什么道路上每隔两块、六块粗糙瓷砖，有一块光滑
• ·影音嗅探专家的使用
• ·she《记得要忘记》的歌谱