Quest Q and A Spring 2010 : Page 37
you have now prepared your list for the query tool. this can be done in both the web version of query and the windows version of query. this article will demonstrate the windows version but simply use the same concept for the web version. first, creating your query based on any other information other than proJect_id. the next thing to do is to setup the criteria for the proJect_id. pull over the proJect_id field onto the query tab and set it equal to an expression. inside this expression is where the magic will occur. first, add the field proJect_id to this expression (yes, we are setting it equal to itself, but you will quickly see what will happen.) next, type in the following: and a.proJect_id in (. now, you are ready for your list from excel. simply copy all of the newly created concatenated fields into this expression. remove the last , (comma) that is on the list and add the ending parenthesis ). you can now execute your query. this will work on any type of data that you may be searching on. if it is a numeric value, do not concatenate the single quotes around the value. also, if your value has zeros in the beginning of the variable, make sure that excel does not eliminate them for you. try it out and let me know what you think. About the Author michael Kepley has been with city utilities of springfield for 20+ years. He has been a developer in it and is now a liaison between finance and it as the manager – financial technology. His primary focuses are project lead, first-line troubleshooter and report specialist. if you have any questions about this article, you can reach michael at mkepley@cityutilities.net. 37
Publication List
