i am new comer in vb programming. i have a project of clinical lab. My database is ready but i can not have an idea where to start reporting.
I have reception form with patient entries for "Patient" table and tests entries for "TEST" table. The TEST table saves only the name of the test, its category, price and report date. Few the tests are actually the tests e.g., Cholesterol. This is test and has values in number. While others are test heading with subheadings. Let us take Urine CE. This is name for Urine examination. So it is having further subtest e.g., colour, density, deposits, sugar, protein, pus cells etc. The result of the Urine CE is saved in another table "URINE". Category means the Deptt. for example, Urine CE belongs to MICROBIOLOGY. Cholesterol belongs to BIOCHEMISTERY. So when i join the tables PATIENT and TEST then the results are not retrieved. For this i have to join many tables and i am unable to join many tables with sql statements. Furthermore for a patient table may have only one or more fields values, others may be empty. i want to eliminate the empty fields to be visible on my reports. i can't accomplish this.