order_rs.Open "SELECT order_no FROM order_info_bak where timestamp like '%" & dd & "%' group by order_no", conn 出错的地方,如果用Group By 那就要把所有查询的字段 Group by ,所以你只 Group by 了 order_no ,所以只能查 order_no,,,,,还有group by 应该放到 where 后面