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  

reports and queries



 
 
Thread Tools Display Modes
  #11  
Old July 26th, 2007, 02:38 PM posted to microsoft.public.access.reports
tryn2learn
external usenet poster
 
Posts: 49
Default reports and queries

I did get the look i wanted, instead i (did what you told me) i made sure to
put the =count(*) in the header that way each colum/group would display it's
total


"Marshall Barton" wrote:

That's good to hear, but what did you do to get the summary
part? I just found out that was the problem and haven't had
a chance to suggest ways to deal with it (I think a
multi-column subreport might be the most appropriate
approach).
--
Marsh
MVP [MS Access]


tryn2learn wrote:
I have read through our prior's and retried it is now working... thank you
again for your help and support in this.

"tryn2learn" wrote:
you're right, this is how it currently looks:
Status Open

TechReq # Assigned To: Manager Requested:
123456789 P Port A Law

TechReq # Assigned To: Manager Requested:
123456789 T Zach A Law

Status Resolved

TechReq # Assigned To: Manager Requested:
123456789 P Port A Law

the report is partially grouped like i want. The "open" is together and the
"resolved" is together with the information for each below it, but i don't
know how to add the collective summary line where is shows how many are in
each:

Open 2 Resolved 1



 




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


All times are GMT +1. The time now is 02: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.