A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Group footer has blank spaces



 
 
Thread Tools Display Modes
  #1  
Old April 23rd, 2005, 04:23 PM
PizzaBoy
external usenet poster
 
Posts: n/a
Default Group footer has blank spaces

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.


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Sorting and using a group footer Melanie O Setting Up & Running Reports 1 March 29th, 2005 11:45 PM
ambiguous outer joins renwick Running & Setting Up Queries 3 February 22nd, 2005 01:29 PM
Blank Page Prints Before Group Fritz Strydom via AccessMonster.com Setting Up & Running Reports 4 January 21st, 2005 08:36 PM
how divide detail by group footer total Dan Setting Up & Running Reports 3 May 25th, 2004 07:28 PM


All times are GMT +1. The time now is 10:53 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.