MDB常规操作

1根据身份证来生成性别

UPDATE cbf_jtcy SET cyxb = iif(mid(cyzjhm,17,1) Mod 2=0,'2','1');

2根据条件设置常规字段

update cbf 
set bz="1"
where cbf.cbfzjhm ="

3更新时间

update cbjyqzdjb 
set djsj=#2019-06-12#

4 判断家庭成员与户主年龄差别

SELECT aa.cyxm,aa.cbfbm,mid(aa.cyzjhm,7,4)as cyyear,aa.yhzgx ,
cbf.cbfmc,mid(cbf.cbfzjhm,7,4) as cbfyear,(cyyear-cbfyear) as 相差多少岁 into bb 
from aa,cbf where aa.cbfbm=cbf.cbfbm