这个查询句子哪错了

lingjiang

肺活量分数: IIf([肺活量]>DMax("指数下限","肺活量评分","年级 & 性别='" [年级] & [性别2] & "'"),DLookUp("得分","肺活量评分","年级 & 性别='" & [年级] & [性别2] & "' and 指数下限=" & DMax("指数下限","肺活量评分","年级 & 性别='" [年级] & [性别2] & "'")),DLookUp("得分","肺活量评分","年级 & 性别='" & [年级] & [性别2] & "' and 指数下限=" & DMax("指数下限","肺活量评分","年级 & 性别='"[年级] & [性别2] & "' and 指数下限<=" & [肺活量])))

lingjiang

如图所示

lingjiang

谢谢您，关于这内部的表是这样的，大四表是参照表，是我进行运算较对的。体重指数评分和肺活量评分是成绩取值范围表，如一个人肺活量吹3000，就要对照肺活量评分按性别来查得分和等级。说白一些就是查表求结果。因为我初学所以向别人要了大四这个表作为参照，以便查看是否正确，目前就发现用此法每次到了低于最低标准时是会出错，例如：体重指数为小于17.8的应为低体重，结果出现了一个16直接就变成了错误！！！！只好加了0到10的取值范围，
另外，这方法也是从本论坛一个学生成绩等级评定启发来的
语法如下：体重指数(BMI)分数: IIf([体重指数]>DMax("指数下限","体重指数评分","性别='" & [性别2] & "'"),DLookUp("得分","体重指数评分","性别='" & [性别2] & "' and 指数下限=" & DMax("指数下限","体重指数评分","性别='" & [性别2] & "'")),DLookUp("得分","体重指数评分","性别='" & [性别2] & "' and 指数下限=" & DMax("指数下限","体重指数评分","性别='" & [性别2] & "' and 指数下限<=" & [体重指数])))
肺活量如下
肺活量分数2: IIf([肺活量]>DMax("指数下限","肺活量评分","年级 & 性别='" & [年级] & [性别2] & "'"),DLookUp("得分","肺活量评分","年级 & 性别='" & [年级] & [性别2] & "' and 指数下限=" & DMax("指数下限","肺活量评分","年级 & 性别='" & [年级] & [性别2] & "'")),DLookUp("得分","肺活量评分","年级 & 性别='" & [年级] & [性别2] & "' and 指数下限=" & DMax("指数下限","肺活量评分","年级 & 性别='" & [年级] & [性别2] & "' and 指数下限<=" & [肺活量])))
前提所有指数下限的数据类型必须是数字

lingjiang

学习了，您的做法和从机器中必体质数据差不多，很有启发。另外国家体质的标分表是有标准的分数段就是那些