>select * from v_avail;
>where villa_id=villas.idcode ;
>and DATE>=thisform.fdate and DATE
if Date is a date field, then i don't understand: "and DATE>=thisform.fdate and DATE" part of your sql query.
is it a date or logical? either way optimize, optimize, optimize, and set optimze on
HI-YO SILVER AWAY!!
The Lone Ranger, The late Clayton Moore R.I.P.
I am a fool!