把你除了用到count,sum,max等函数以外的字段名全都加到group by 后面 (你这个Sql语句中没有这些函数,所以Group by是没有意义的)变通的方法 select count(*) as cnt,rpfail.id,rpfail.name,company.industry,rpfail.xyear,rpfail.season from rpfail,company where fpfail.xyear=" & frmmain.iTheYear _ & " and rpfail.name=company.name and rpfail.season='" & frmmain.sTheSeason _ & "' and rpfail.type=true group by rpfail.id,rpfail.name,company.industry,rpfail.xyear,rpfail.season,rpfail,company
(你这个Sql语句中没有这些函数,所以Group by是没有意义的)变通的方法
select count(*) as cnt,rpfail.id,rpfail.name,company.industry,rpfail.xyear,rpfail.season from rpfail,company where fpfail.xyear=" & frmmain.iTheYear _
& " and rpfail.name=company.name and rpfail.season='" & frmmain.sTheSeason _
& "' and rpfail.type=true group by rpfail.id,rpfail.name,company.industry,rpfail.xyear,rpfail.season,rpfail,company