report with yes/no boxes

[sadie]

I have a sub form with yes/no boxes to check with client characteristics on admission to a program and upon discharge

How can I make a report so that these characterists can be compared

 

[Fizzio]

How do you want them compared?

 

[sadie]

so I can see what characteristics were checked at admission and which onews were checked at discharge

 

[Fizzio]

I would be inclined to do this with a report / subreports structure. In the main form, display the client data - name etc then have separate subforms for admission data and discharge data.

 

[sadie]

should I have a separate subform for amission and another one for discharge???
Right now I have a subform with both admission and discharge

 

[Fizzio]

You can have one or two reports. The advantage of having two is that you can display the results side-by-side.

 

[sadie]

I made 2 reports in columns
one has the characteristics on admission, one has them on discharge
I tried to do a sub report to have them together on one report
It shows up fine in design view but when I go to report view only the first column shows
Is there a better way to join these 2 reports into one for comparison

 

[Fizzio]

The main report shows the client info. Each subreport shows the admission / discharge data. You will need to set the child/master links to the ClientID field (most likely) and both reports will show - provided that they have information in them.