>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.
HI-YO SILVER AWAY!!
The Lone Ranger, The late Clayton Moore R.I.P.
I am a fool!