sql 查询 货币有关问题

sql 查询 货币问题
在ACCESS中
 有个货币字段
  money

我要搜索 价格在 5-10的查询语句该怎么写？~

------解决方案--------------------------------------------------------
where money between 5 and 10
------解决方案--------------------------------------------------------
select * from table1 where 5<money<10
------解决方案--------------------------------------------------------

探讨

where money between 5 and 10

------解决方案--------------------------------------------------------

探讨

select * from table1 where 5 <money <10

------解决方案--------------------------------------------------------

探讨

引用:
where money between 5 and 10

------解决方案--------------------------------------------------------
up
------解决方案--------------------------------------------------------

where [money] between 5 and 10

------解决方案--------------------------------------------------------
where money > 5 and money < 10
------解决方案--------------------------------------------------------

探讨

where [money] between 5 and 10