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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only