您所在位置：主题：SQL转ACCESS的两个小问题
zaliang
[专家分：1010] 发布于 2006-04-21 15:15:00
原先做了一个SQL版的系统,现想转一个ACCESS版的.可是.遇到了两个问题,请大侠门帮忙纠正:
1: s:=s+' JMSJ>='+datetostr(datetimepicker1.Date)
+' and jmsj<='+datetostr(datetimepicker2.date);
问:为什么我的查询语句一加这一行代码就查询不出数据???(access库里的表结构中JMSJ字段类型:日期时间型;
2:
s:='select c.bh as 编号,m.HYKH as 会员卡号,HYXM as 会员姓名,XB as 性别,KLX as 会员卡类型,'
+' c.HYDJ as 会员卡等级,SFJE as 消费金额,XFRQ as 消费日期,'
+' [color=FF0000]floor[/color](SFJE/10) as 所得积分,m.BZ as 备注说明,lxdh as 联系电话'
+' from meminfo m,memconsume c, memrank r'
+' where m.HYKH=c.HYKH and m.KDJ=r.BH';
问2:floor在SQL中是取整的意思,要换在ACCESS中上面的查询语句应当如何更改?(提示错误:floor函数未定义);
1: s:=s+' JMSJ>='+datetostr(datetimepicker1.Date)
+' and jmsj<='+datetostr(datetimepicker2.date);
问:为什么我的查询语句一加这一行代码就查询不出数据???(access库里的表结构中JMSJ字段类型:日期时间型;
2:
s:='select c.bh as 编号,m.HYKH as 会员卡号,HYXM as 会员姓名,XB as 性别,KLX as 会员卡类型,'
+' c.HYDJ as 会员卡等级,SFJE as 消费金额,XFRQ as 消费日期,'
+' [color=FF0000]floor[/color](SFJE/10) as 所得积分,m.BZ as 备注说明,lxdh as 联系电话'
+' from meminfo m,memconsume c, memrank r'
+' where m.HYKH=c.HYKH and m.KDJ=r.BH';
问2:floor在SQL中是取整的意思,要换在ACCESS中上面的查询语句应当如何更改?(提示错误:floor函数未定义);