"Alejandro E." <sitma@sinfo.net> wrote:
>
>
>>rs.Open "select * from tablea where date-one >=" & Variable1 & " And date-one

><= " & Variable2, cn, adOpenKeyset, adLockReadOnly
>
>when i use this statement i get the error: not value for something parameter,
>and if i use the [date-one], i get the error: divide by zero
>..
>..
> dd/mm/yy
>the table have record before 30/05/00
> dd/mm/yy
>the Variable1 have 01/05/00
>the Variable2 have 30/05/00
>have someone any idea...
>
>please ,,,, excuse me, but i am ofuscated
>
>thanks for alll