Error en select, la primera vez

[dguerr]

Este es el Select, les recuerdo que el error lo muestra la primera vez, al actualizar o pressionar F5 me funciona ok.


sql="select distinct coord,central,tele,dispo+subdispo,causa+subcausa,s ubstr(tclo,7,2)+'/'+substr(tclo,5,2)+'/'+substr(tclo,1,4)+' '+substr(tclo,9,2)+':'+substr(tclo,11,2),cleaid1,r ep1,ca1,arm1 from acumnac as t1 where "&_
"tele=(selec tele from acumnac where t1.tclo<acumnac.tclo and acumnac.causa<>'5' and acumnac.causa<>'7' and acumnac.dispo<>'19' and acumnac.dispo<>'17' and acumnac.dispo<>'13' and acumnac.causa<>'6' and acumnac.tclo >='" & ano1+mes1+dia1 & "' and acumnac.tclo<='" & ano2+mes2+dia2 & "') "&_
"and clsid='" & dac & "' and area1='" & coord & "' and (date(val(substr(t1.tclo,1,4)),val(substr(t1.tclo, 5,2)),val(substr(t1.tclo,7,2))) - date(val(substr(acumnac.tclo,1,4)),val(substr(acum nac.tclo,5,2)),val(substr(acumnac.tclo,7,2)))) < 30 "&_
"and t1.causa<>'5' and t1.causa<>'7' and t1.dispo<>'19' and t1.dispo<>'17' and t1.dispo<>'13' and t1.causa<>'6' "&_
"order by t1.tele,t1.tclo "