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  

Invisible Group Footer



 
 
Thread Tools Display Modes
  #1  
Old November 23rd, 2005, 06:39 PM posted to microsoft.public.access.reports
external usenet poster
 
Posts: n/a
Default Invisible Group Footer

Hello there

I have report that shows data on companies
Each company has sometimes sub company

The report is summerize data of company and sub company

If i have only one sub company the group footer of the subcompany should not
be visible.

How can i do that?



  #2  
Old November 23rd, 2005, 07:18 PM posted to microsoft.public.access.reports
external usenet poster
 
Posts: n/a
Default Invisible Group Footer

Roy Goldhammer wrote:
I have report that shows data on companies
Each company has sometimes sub company

The report is summerize data of company and sub company

If i have only one sub company the group footer of the subcompany should not
be visible.



You didn't provide enough information for me to be specific,
but I'll take a guess that the subcompany data is in the
report's detail section. If so then add a hidden text box
named txtDtlCnt to the footer section and set its control
source expression to =Count(*)

With that in place add a line of code to the group footer
section Format event:
Cancel = (Me.txtDtlCnt = 1)

--
Marsh
MVP [MS Access]
 




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
Not print group header when group footer prints Kate Setting Up & Running Reports 1 July 7th, 2005 05:24 AM
Keep Together last record detail with group footer Craig Setting Up & Running Reports 1 May 18th, 2005 07:33 AM
Ambiguous outer joins Renwick New Users 1 February 22nd, 2005 03:08 PM
Syntax needed to get needed reports Frank Lueder New Users 15 January 6th, 2005 09:39 AM
Using DCount in Group Footer filtering records based on value of the group Beth Setting Up & Running Reports 1 September 10th, 2004 04:17 PM


All times are GMT +1. The time now is 06:22 PM.


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