>Hi Colin,
>
>Can you loop through the fields checking to see if there !empty and building the WHERE clause on the fly.
>
>How are you building these queries?
>
>Jon
>
>>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


Jon

Yes I could - it's what I'm looking for - can you give me an example of how to build the where clause on the fly?

Thanks

Colin