Question

access中条件语句怎么写，比如查询20分到50分之间的数据

access中条件语句怎么写，比如查询20分到50分之间的数据，
这么写对么

Answer 1

不知道是不是你要的效果，，，
直接用between and就可以了
select * from 表 where 字段 between 20 and 50

Answer 2

select * from table where column between 20 and 50

Answer 3

between 20 and 50
between >20 and <50