how to join tables

[ieesab]

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.

[Ecniv]

Read up on joins, specifically left joins.

Then you would need to list all the patients and left join to the other tables to pull back information.

Possibly you could have a reports table (temporary?) to hold the data in, then you can run a series of sql statements to fill the table with the data for outputting and run the report off that table.

Have a look in the database forum section here, I think it is the second or three pinned thread that has info on joins.. mostly accurate info.