我做了个统计人数的表单
用到 luru\jp\hz\zj 四个表，如下代码，在 &sele1时出错？

sele1=IIF(thisform.check1.Value=1 ," select COUNT(sfzh) as 66 from luru " , "" )
sele1=IIF(thisform.check2.Value=1 ,IIF(!EMPTY(sele1),sele1+" union select COUNT(sfzh) as 66 from jp "," select COUNT(sfzh) as 66 from jp ") , sele1 )
sele1=IIF(thisform.check3.Value=1 ,IIF(!EMPTY(sele1),sele1+" union select COUNT(sfzh) as 66 from zj "," select COUNT(sfzh) as 66 from zj ") , sele1)
sele1=IIF(thisform.check4.Value=1 ,IIF(!EMPTY(sele1),sele1+" union select COUNT(sfzh) as 66 from hz "," select COUNT(sfzh) as 66 from hz ") , sele1)
sele1=IIF(!EMPTY(sele1),sele1+" into curso dfd","")

&sele1×××××××××××这句出错

木看明白

楼主这样判断多条件是不对的，怎么不用do Case …… 循环？如果非要这样做又不会调试程序的话，先不要执行&sele1,而是先检查一下“sele1”内容有什么不对：
?sele1
*&sele1

[ 本帖最后由 qjbzjp 于 2013-3-18 15:43 编辑 ]

你那代码变一下就是如下功能(注 不要用 66  作字段名),觉得你应用 UNION ALL
SELECT COUNT(sfzh) as n66 from luru INTO CURSOR dfd WHERE thisform.check1.Value=1;
UNION ALL SELECT COUNT(sfzh) as n66 from jp WHERE thisform.check2.Value=1;
union ALL SELECT COUNT(sfzh) as n66 from zj WHERE thisform.check3.Value=1;
union ALL SELECT COUNT(sfzh) as n66 from hz WHERE thisform.check4.Value=1

或

sele1=''
IF thisform.check1.Value=1
    sele1=sele1+"select COUNT(sfzh) as n66 from luru union ALL "
ENDIF

IF thisform.check2.Value=1
    sele1=sele1+"select COUNT(sfzh) as n66 from jp union ALL "
ENDIF

IF thisform.check3.Value=1
    sele1=sele1+"select COUNT(sfzh) as n66 from zj union ALL "
ENDIF

IF thisform.check4.Value=1
    sele1=sele1+"select COUNT(sfzh) as n66 from hz union ALL "
ENDIF

IF NOT EMPTY(sele1)
    sele1=LEFT(sele1,LEN(sele1)-10)
    sele1=sele1+" into curso dfd"
    &sele1.
ENDIF


[ 本帖最后由 kiff 于 2013-3-18 18:17 编辑 ]

逐条代码进行判断，看看是那条代码出问题了

肿么能用数字作为标题呢？楼主的基本功有待加强啊。