Statistics in report header

[nurserich]

I am creating a patient shift report form. At the top of this report is usually a ribbon indicating the total census, followed by which rooms have pending admission, which have pending discharges, etc.


In my form, I have checkboxes indicating whether this patiet is a pending admission or discharge, with the room indicated in a seperate field. I am trying to get the status ribbon at the top of the report to indicate which rooms will have discharges and admissions based on the affirmative checkbox. As an example> Mary is a patient in room 202, but she will be discharged today. I check the discharge box. The textbox on the ribbon indicates "202" under the discharge title. Thanks.

[June7]

No idea what you mean by 'status ribbon'. What do you mean 'usually a ribbon'? What ribbon?

[nurserich]

No idea what you mean by 'status ribbon'. What do you mean 'usually a ribbon'? What ribbon?

In the header of the report is a summary of the unit data.
Census:
Admissions:
Discharges:
Psychiatric Emergencies:
Nut Allergies:
Recertifications:
Belongings Search:
ECT procedures:
Drug resistant Organisms:

The census is the number of patients on the unit.
Admissions will show room numbers corresponding to patients due to be admitted: 201, 203A, etc....
Each other category is the same as Admissions. Each category corresponds to a yes/no check box on the form. On this summary header, I want the report to look at which patient's have the check box marked and reflect the room number under the appropriate heading (Admissions, Discharges, etc...).

I have made Census populate the number of patients on the unit by adding

=Count(IIf([PatientT]![Unit]="2W" And ([PatientT]![Active]="Yes"),1,0))

to the control source of the text box in the report header. Unfortunately, when I run the report, a popup box requesting parameters comes up for the unit name, which is specified in the query, and the active yes/no check box, which is marked yes in the query.

Thanks

[June7]

So your 'ribbon' is just a row of unbound textboxes that need some expressions in their ControlSource property?

If you have 5 patients for discharge, you want all those room numbers to show in the header?

One room number or five, what you want won't be easy. I need better understanding of db. If you want to provide for analysis, follow instructions at bottom of my post.

[nurserich]

Thanks for the help. It seems as though you understand what I mean. I have tried to upload a version in which the confidential information is deleted,...but I was unable to do so due to file size. The file is less than the 2 MB, but the attachment manager did not allow the upload. On these computers, I do not have a way to compress the file.

[June7]

You don't have Windows Compression? It's part of Windows Explorer. Right click on file > Send To > Compressed (zipped) Folder.

Alternative is upload to fileshare site such as Box.com and post link to the file.