i have an access database with about thirty tables, each table have about ten or more coumns or fields. one patient may have different tests from different tables of the database. i am stuck up to generate reports, especially of one patient with tests from different tables and single report with all the test results on it. how can i generate such reports in vb6 and how can i join the tables by sql parametrized queries. please help me.