出错信息:试图执行一个合计函数不包含特定表达式'图书编号'的查询
str = "Select top " & RecoTxt.Text & " index as 图书编号,name as 图书名称
,type as 图书类型,sum(borrowtime) as 借阅次数 from bookmessage"
str = str & " group by type order by sum(borrowtime) desc"BookMessageData.RecordSource = str
BookMessageData.Refresh表中确实有index,name,type,borrowtime字段
str = "Select top " & RecoTxt.Text & " index as 图书编号,name as 图书名称
,type as 图书类型,sum(borrowtime) as 借阅次数 from bookmessage"
str = str & " group by type order by sum(borrowtime) desc"BookMessageData.RecordSource = str
BookMessageData.Refresh表中确实有index,name,type,borrowtime字段
,type as 图书类型,sum(borrowtime) as 借阅次数 from bookmessage"
str = str & " group by index,name,type order by sum(borrowtime) desc"
INDEX 关键字被使用在这些上下文之中: CREATE INDEX 语句 DROP 语句 GRANT 语句 REVOKE 语句 不妨改名试试?