G
Guest
I have a report is supposed to be only one page showing the room, beds for
the facility which are occupied and which are empty. The report shows the
room and bed number information in labels with the related info from
expressions.
Example:
Room # Bed # Patient Name
B1-1 1 =iif([RoomNo]="B1-1" and [BedNo]="1",
[firstname]&" "&[lastname],"")
2 =iif([RoomNo]="B1-1" and [BedNo]="2",
[firstname]&" "&[lastname],"")
The expression works except that it prints only one patient per page. The
query shows the correct information. How do I solve getting it to a one page
report? Your help will be greatly appreciated.
the facility which are occupied and which are empty. The report shows the
room and bed number information in labels with the related info from
expressions.
Example:
Room # Bed # Patient Name
B1-1 1 =iif([RoomNo]="B1-1" and [BedNo]="1",
[firstname]&" "&[lastname],"")
2 =iif([RoomNo]="B1-1" and [BedNo]="2",
[firstname]&" "&[lastname],"")
The expression works except that it prints only one patient per page. The
query shows the correct information. How do I solve getting it to a one page
report? Your help will be greatly appreciated.