Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

For Trygve only, e-mail question

Posted on 1999-07-02
4
Medium Priority
?
235 Views
Last Modified: 2006-11-17
Hi Trygve,
Thanks for the help with the report.
I'll give you 60 points for that!

Many thanks!!
0
Comment
Question by:banan
[X]
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
  • 3
4 Comments
 
LVL 12

Accepted Solution

by:
Trygve earned 240 total points
ID: 1998682
Always glad to help.

For the record; This is a project/report that I have helped banan with on some occations.

The setup

Report based on crosstab query
Each column summed into a grouping footer. Summa_AKI = Sum([AKI])
In the same footer the sums are added Summa_Tot = Summa_AKI + Summa_CTI ...

How to get an overall total. banan tried with =Sum([Summa_Tot]) but this failed.

Answer:
To get the overall total you need this

=Sum(nz([AKI];0)+nz([BRD];0)+nz([MAN];0)+nz([MAN];0)+nz([RKI];0)+nz([SLU];0)+nz([SM1];0)+nz([SM2];0))

When summing on the report you always need to use the original fields in the sum expressions. The controls on the report can only be used for normal expressions (=Field1+Field2) etc.

0
 
LVL 12

Expert Comment

by:Trygve
ID: 1998683
Are you there banan?
0
 

Author Comment

by:banan
ID: 1998684
I am Sorry. Here are the points.

Regards
0
 
LVL 12

Expert Comment

by:Trygve
ID: 1998685
You are forgiven :-)

Trygve
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

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

AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

705 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