come faccio questa array

[kalosjo]

select count(*) from tabprodcont where id_contratto in (select distinct idcontratto FROM tabcontratto WHERE codiceagente = '"&agente&"' AND accettato = true AND datacont BETWEEN #"&strdaData&"# AND #"&straData&"#)"