>Colin
>
>Not sure whether the following would work, or fail if just one criterion is not fulfilled, but you can give it a bash:
>
>

>Select .... from ... ;
>where Town = lcInputTown and not EMPTY( lcInputTown) ;
>  and Country = lcInputC and not EMPTY( lcInputC ) ;
>  and ZipCode = lcInputZip and not EMPTY( lcInputZip ) ;
>  and ...
>  into cursor PostmansSock NOFILTER
>

>Note that the NOFILTER clause enables the resultant cursor to be used in your next query, as in
>
>Select ... from PostmansSock ...
>
>If this is connected to your previous question re: "Query is read-only", then, in the query builder, you can open the SQL window and still select and copy the SQL, to get the bulk/essence of it, and paste it into your code, to do the above enhancements.
>
>HTH
>
>Terry
>
Terry - thanks for that but it fails if one of the criteria is not fulfilled

>
>
>>Hi
>>
>>I am trying to work out the code for the following
>>
>>I have 12 query fields - any or all may contain values - I only want SQL to run the query on those fields where the query field is non blank
>>
>>eg Town = New York Country = USA zipcode (blank)
>>
>>The query would only work on town and country since the zipcode field is blank
>>
>>Alternatively I might have to run a number of queries one after using the results from query 1 as the source data for query 2 - is there any way I can do this?
>>
>>Thanks
>>
>>Colin