C ckzn Unregistered / Unconfirmed GUEST, unregistred user! 2002-06-27 #1 在access中如何写这些select: 1.where条件是日期与日期型字段比较 2.where条件是数值与小数字段比较 3.where条件是字符串与文本字段匹配
C Cardinal Unregistered / Unconfirmed GUEST, unregistred user! 2002-06-27 #2 呵呵，没分，就没人回答了阿 可以先在Access里用SQL环境测试一下，那样容易解决出错问题 1.select * from BasicInfo where 出生日期 between '#1979-1-1#' and '#1980-1-1#' 2.select * from BasicInfo where 工资>5000 3.select * from BasicInfo where 姓名＝‘章三’
呵呵，没分，就没人回答了阿 可以先在Access里用SQL环境测试一下，那样容易解决出错问题 1.select * from BasicInfo where 出生日期 between '#1979-1-1#' and '#1980-1-1#' 2.select * from BasicInfo where 工资>5000 3.select * from BasicInfo where 姓名＝‘章三’
L lipeng2002 Unregistered / Unconfirmed GUEST, unregistred user! 2003-05-15 #5 1.select * from 表名 where datediff('字段名称', '1979-1-1' , '1980-1-1') 2.select * from 表名 where 字段名称>100 3.select * from 表名 where 字段名称='I love'
1.select * from 表名 where datediff('字段名称', '1979-1-1' , '1980-1-1') 2.select * from 表名 where 字段名称>100 3.select * from 表名 where 字段名称='I love'
