title: Access 2007 iterate through a saved query
body: <p>I am working with a fairly large database of information.  I need to use a distinct set of values in one saved query as the parameter in the 'where' clause for another query.  What is the best way to iterate through the result set of distinct values?  I am fairly new to Access and VBA.</p>