I have created several programs that store data in databases.  I include with 
them several queries to generate reports.  There can be a wish for a few more 
reports.  Sometimes I modify the application to incorporate the new reports.  

I thought it would be good to have queries and reports that were 'data driven'.  
My next thought was why complicate the data entry application with a data 
driven report generator?

Years ago I created a command line program that could take query and database 
connection information from its INI file and generate a crude report.

I have created a better solution: QueryMgr.  It uses the abilities of my other 
applications; TktMgr, SurvyMgr and Gastro to take a query and an existing 
database to generate a report, displayed in MS Excel or a Web Browser.  That is 
code reuse!  I believe that QueryMgr can be a handy self-sufficient companion 
tool to use with my other applications and other situations.

QueryMgr connects to a database (MSAccess) and lists all off its Tables and the 
Table's Fields.  It can also list the built-in Queries and their Fields.  I 
have included buttons for most, but not all of the SQL SELECT query keywords.  
You can type in anything else you need.  You can also copy and paste any query 
you like.

QueryMgr does have a simple query Diagnostic process.  I have improved the
Diagnostic routine quite a bit.  I have had successful Unit Testing with UNION 
and CrossTab queries.  No program is perfect but I hope this is a real help.  
At this point it cannot cope with the very complex queries.  I will continue 
to improve it.  There is always room for improvement.  
You can easily click [OK] and disregard it or you can use the 
File/Configuration/... menu option to enable or disable it.

All of my applications have been proven with MSAccess 2000.  The biggest 
uncertainties lie with the major changes that came with MSAccess 2007 and 
2010 ... .