如何把年龄字段里的记录都加1，并且后面对应的年龄分布阶段变为1？例如：

图片附件: 游客没有浏览图片的权限，请 登录 或 注册

[ 本帖最后由 Kerberos 于 2014-1-17 09:50 编辑 ]

你这表文件名和字段名都是汉字啊  也太。。。。。。。

REPLACE ALL 年龄 WITH TRANSFORM(VAL(年龄)+1)

REPLACE 介于36至45 WITH '1' FOR  VAL(年龄)>=35 AND VAL(年龄)<=45
其它的类推

上帝  你的年龄 字段  还有 什么小于35字段啥的  咋都是字符型呢   晕死了

update 岗位分类表  set 小于35 = "1" where 年龄<"35"

REPLACE ALL 年龄 WITH TRANSFORM(VAL(年龄)+1)
REPLACE ALL 小于35  WITH IIF(VAL(年龄)<36,"1",""),;
                介于36至45  WITH IIF(BETWEEN(VAL(年龄),36,45),"1",""),;
                介于46至55  WITH IIF(BETWEEN(VAL(年龄),46,55),"1",""),;
                大于56  WITH IIF(VAL(年龄)<55,"1","")

REPLACE ALL 年龄 WITH TRANSFORM(VAL(年龄)+1)
REPLACE ALL 小于35  WITH IIF(VAL(年龄)<36,"1",""),;
                介于36至45  WITH IIF(BETWEEN(VAL(年龄),36,45),"1",""),;
                介于46至55  WITH IIF(BETWEEN(VAL(年龄),46,55),"1",""),;
                大于56  WITH IIF(VAL(年龄)<55,"1","")

加10分

收到的鲜花

• qjbzjp 于 2014-01-22 10:54 送鲜花  10朵   附言：加10分 ^_^

感谢各位大神~~~~~~~~~~

1.尽量不要对原表操作，故用一临时表temp。
2.年龄和之后字段参与数值运算，最好是改为数值型字段，而不是现在的字符型字段
3.有一个年龄字段足够，需要什么年龄段统计即可，小于35等字段可以不用，也免得让数据显得凌乱。

***生成临时表
Select * From 岗位分类表 Into Cursor temp Readwrite
***所有年龄加1岁
Replace 年龄 With Transform(Val(年龄)+1) All
***统计替换各年龄段方法1，但意义不大
Replace  All 小于35  With Iif(Val(年龄)<36,"1",""),;
    介于36至45  With Iif(Between(Val(年龄),36,45),"1",""),;
    介于46至55  With Iif(Between(Val(年龄),46,55),"1",""),;
    大于56  With Iif(Val(年龄)>55,"1","")
Browse
***统计查询各年龄段人数，这样就足够了，其实不需要上面的replac
Select Count(*) 总人数,Sum(Iif(Val(年龄)<36,1,0)) As "小于35",;
    sum(Iif(Val(年龄)>=36 And Val(年龄)<=45,1,0)) As "介于36至45", ;
    SUM(Iif(Between(Val(年龄),46,55),1,0)) As 介于46至55 ,;
    SUM(Iif(Val(年龄)>55,1,0)) As 大于56 ;
    FROM temp

***统计替换各年龄段方法2，但意义不大
Replace 小于35  With "1" For Val(年龄)<36
Replace 介于36至45 With "1" For Between(Val(年龄),36,45)
REPLACE 介于36至45 With "1" For Val(年龄)>=36 AND  Val(年龄)<=45
Replace 介于46至55 With "1" For Between(Val(年龄),46,55)
Replace 大于56  With "1" For Val(年龄)>55

[此贴子已经被作者于2024-8-8 14:49编辑过]