Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Report Sub-Count and Total Count

Posted on 1998-02-16
3
443 Views
Last Modified: 2006-11-17
I have a report broken into Categories. What I require is a sub-count for each category and a report total combining all the sub-totals.  I'm using Access 7, and currently use "=count(*)" in the report footer, but I can't firgure out the sub-totals? Sometimes I see the formula on the actual report?  Also my total for my invoice only shows the cost of the last item in the list vice a combined total for all the items?
0
Comment
Question by:DWB
  • 2
3 Comments
 

Author Comment

by:DWB
ID: 1968578
Edited text of question
0
 

Author Comment

by:DWB
ID: 1968579
Adjusted points to 50
0
 
LVL 5

Accepted Solution

by:
cekman earned 50 total points
ID: 1968580
In the category group footer simply create an unbound text box and put the following in the controlsource property:

=sum([fieldname])

where fieldname is the name of the field you want to total - for example [amount]

Repeat this exact same thing in the Report Footer for a grand total.

Good luck
CEkman

0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

860 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question