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