I have successfully created a query to pull data into an excel spreadsheet
from SQL. The problem is that I have about 10 select count(*) statements that
pull pretty much from the same tables with different criteria. Once I've
create the first query, I can't seem to figure out how to create another one
as the create new query is greyed out. In looking at the script that gets
created from using the wizard I can't seem to figure out how to duplicate it
and where the value will fill in. Can anyone shed some insight on the easiest
way to fill cells in based on data from one cell, but bring the data back
into multiple cells using multiple queries? Thanks Rick