Originally Posted by
alansidman
I can't envision an easy way for this. Do you need to run the query for all 10000 sites or will it be on an adhoc basis? As to the running for months, I would use a search form that would prompt the user for the particular month to query. Unless it is on an adhoc basis, then I might use a list box on a search form to select the particular sites you would wish to have run.
I imagine that you could run a loop through the data set employing VBA, but I cannot help you with that--maybe someone with more VBA experience could show you the way.
Alan
Bookmarks