Re: Any suggestions ?

Użytkownik Mike napisał:

> Luc
> Many many thanks for your very quick reply.......appreciated. I have
> tried your statement but now get the following response :
> Expected end of statement
> strSQL = "select * from "Cottages", "Pricebands" where "Location" = '&
> strLocation &' and "Price Number" = '& strDates &' and "Bedrooms
> Number" = '& strRooms &' and "Pets" = '& strPets &'"
>
> Any quick solution ? any chance I could email you the page for you to
> look at in context ??
>

If you wan't quick, i try give it to you.

First, 'expected end of statetment', for me means that is lack of ';' or '/'.

So please try:

strSQL = "select * from "Cottages", "Pricebands" where "Location" = '&   strLocation &' and "Price Number" = '& strDates &' and "Bedrooms   Number" = '& strRooms &' and "Pets" = '& strPets &';"

-- 
Noel