Help with a report

[svbl]

Here's a review of how my form is like. I have a subform for Diagnosis for each patient. Each patient can have more than one diagnosis and within the diagnosis types, ONE of the diagnosis has additional subcatergories. I put those subcatergories in a separate table, Diagnosis2.

What I want to happen to my report is to show (in text) what the subcatergores are for each patient and not the subcatergory ID, which is what I can only get. I tried putting the Diagnosis2 control in place of the Diagnosis2ID, but when doing this so, the main Diagnosis column would return me ONLY values that contains a subcatergory and I no longer see the other diagnosis.

Any help would be appreciated.

Please look at the attachment for a visual of what I described if what I said doesn't make sense (put cursor over image and then a control will appear on the lower right hand corner of the image for you to press to maxmize the image view).

 

[HiTechCoach]

You will probably get a lot quicker response is you type you question within the post. Also, your attachment was not easy to figure out.

The issue is the when you added you subcategory table, you need to change the join type to include all even if there is not a matching sub category.

Another option is to place a combo box control on the report to lookup the sub category description.


Hope this helps ...

 

[svbl]

Thank you, HiTechCoach.

I'm not quite sure what you mean by,

The issue is the when you added you subcategory table, you need to change the join type to include all even if there is not a matching sub category.

and as for placing a combo box control, that would be useful and good idea, but what if I wanted to print the report? That would mean I would have to print a separate sheet for diagnosis2 to indentify which ID is which diagnosis2 and it could be a little irritating. If it's possible to have it all on that one report then that would be best.

 

[HiTechCoach]

If you were to use a combo box, your report would work exactly the way it is now. You would just change the text box to a combo box.


I would recommend that you fix the query. Add the table to the query, then right-click on the lien that joins the tables to view the join properties. Select the join type (the second or third option, not the top one) that is all the records from the desired table and only the matching from the "Diagnosis2" table. This is called an outer join.