In table newgudong field "NMD", need to get the same stock code from the table GGJC years plus the number of statistics, the number of positions and the number of statistics is inserted into a table newgudong "NMD" in the field, and can complete the calculation, the batch consult written below where I went wrong, or the trouble the teacher you help write a, thank you! :

<%
Dim conn
Set the conn=Server. CreateObject (" ADODB. Connection ")
Conn. Execute (" insert into newgudong NMD values (select count (*) as the total from GGJC where newgudong. Stockid.=GGJC stockid and datediff (' d ', bddate, now ()) & lt; ")
=365)Set the conn=nothing
% & gt;