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