>select * from v_avail;
>where villa_id=villas.idcode ;
>and DATE
>However it seems to be the AND CLAUSE in the
>DATE>=thisform.fdate AND DATE which is causing the problem.

>Can I set up and index to accomodate this ?
>or
>Is there another workaround

I assume DATE is a logical field right? If it's not indexed maybe you should, if not for anyother reason, for the query reason, (yes, you can index on a logical field). Make sure your where clause mirrors the indexes of the tables and "set optimize on" before executing the sql query.