P
PizzaBoy
Hello Group. I have a report based on a query with one group footer which
has only one text box with nested IIF statements. The underlying query is
based on two tables with a one to many relationship. The first table
contains the building and unit name. The second table contains each
reservation for that building and unit. The report is designed so it groups
on the unit number and it counts the number of reservations per unit. The
group footer's text box has an IIf statement which is supposed to show only
those units who have less than 3 total reservations. Text
box=(IIf(count(IIF([LETYPE]="F",1,null))<3,"Building"&"Unit",null) The IIF
statement works properly but since there are no other text fields the report
shows extra blanks spaces equivalent to the total number of units in the
first table. I would assume this is because it is in a grouped footer. How
do I eliminate the extra blank spaces and only show the text box results?
(This is not a can grow/can shrink issue-already tried it)
If there is an easier way to do this please let me know. Thank you.
has only one text box with nested IIF statements. The underlying query is
based on two tables with a one to many relationship. The first table
contains the building and unit name. The second table contains each
reservation for that building and unit. The report is designed so it groups
on the unit number and it counts the number of reservations per unit. The
group footer's text box has an IIf statement which is supposed to show only
those units who have less than 3 total reservations. Text
box=(IIf(count(IIF([LETYPE]="F",1,null))<3,"Building"&"Unit",null) The IIF
statement works properly but since there are no other text fields the report
shows extra blanks spaces equivalent to the total number of units in the
first table. I would assume this is because it is in a grouped footer. How
do I eliminate the extra blank spaces and only show the text box results?
(This is not a can grow/can shrink issue-already tried it)
If there is an easier way to do this please let me know. Thank you.