public tian,lings,shils
tian=thisform.text7.value
*select jjgz
select jjgz.rybh,jjgz.riqi from jjgz;
DISTINCT where ;
jjgz.rybh=thisform.combo3.value;
and year(jjgz.riqi)=thisform.text5.value;
and month(jjgz.riqi)=thisform.text6.value;
and jjgz.ling<>0;
into cursor lingtemp
select lingtemp
count to lings
*count for jjgz.rybh=thisform.text4.value;
* and year(jjgz.riqi)=thisform.text5.value;
* and month(jjgz.riqi)=thisform.text6.value;
* and jjgz.shil<>0;
* to shils
select jjgz.rybh,jjgz.riqi from jjgz;
DISTINCT where ;
jjgz.rybh=thisform.combo3.value;
and year(jjgz.riqi)=thisform.text5.value;
and month(jjgz.riqi)=thisform.text6.value;
and jjgz.shil<>0;
into cursor shiltemp
select shiltemp
count to shils
report form jjgz for jjgz.rybh=thisform.combo3.value and;
year(jjgz.riqi)=thisform.text5.value;
and month(jjgz.riqi)=thisform.text6.value;
PREVIEW
查询语言是这样的,在本机查有记录,在别的机查却空白没记录