473,405 Members | 2,349 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,405 software developers and data experts.

Error in grandtotal for the Main Report containing subreports

I m getting Error in grandtotal for the Main Report containing subreports...

Main report contains 2 subreports which sometimes show error in the grand total...

My Expression is Sum(NZ([Column Name],0)) but still receiving error...

Can anyone help me with this???
Jan 8 '10 #1
7 2040
MMcCarthy
14,534 Expert Mod 8TB
OK it's not clear what you are doing. If Sum(NZ([Column Name],0)) is the expression for the main report total where is [Column Name]. If it is in the subreports then this will not work.

Have you the same expression in the subreports? You will need to give a lot more information before anyone can help I'm afraid.
Jan 8 '10 #2
Sum(NZ([Column Name],0)) is the expression for 1 of my subreports.Use of the Nz function is to set 0 for the grandtotal but still this expression shows me Error..

Becoz of this subreport I m getting Error for total grandtotal in my Main Report...What expression should i use in the subreport & in the Main Report so that i don't get the Error for the Grandtotal in my Main Report
Jan 9 '10 #3
MMcCarthy
14,534 Expert Mod 8TB
If it is showing an error then there is something wrong with the values in the column you are trying to sum. Check the data type of the column and make sure it is set to numeric type.
Jan 9 '10 #4
NeoPa
32,556 Expert Mod 16PB
There is far too little detail in your question to be much help (Access is more of a science than an art. You need to be precise with your details) but see if this link (Referring to Items on a Sub-Form) helps.
Jan 11 '10 #5
datatype is set to numeric..but still getting the error
Jan 11 '10 #6
NeoPa
32,556 Expert Mod 16PB
I don't know if you've noticed, but you've been told on a number of occasions already that you have not supplied enough information to work with. Your latest post is a further example of providing almost nothing. Please consider what you can do to help us to help you. As it is you appear to be doing very little, in which case we can only assume you don't care very much about the problem.
Jan 11 '10 #7
i m really very sorry...I wil surely b writing in detail for any of my queries further....
Jan 12 '10 #8

Sign in to post your reply or Sign up for a free account.

Similar topics

0
by: MushMouse | last post by:
I have a report in which I have 2 subreports, each with a subtotal in the report footer. I'd like to add the 2 subtotals together in the main report. If one of the subreports doesn't have data for...
7
by: Jacob Barnett | last post by:
Access 2000 main report does not display subreport data in preview and may or may not print... sometimes. Usually, the entire report is fine. The behavior does not seem to depend on particular...
3
by: Edward | last post by:
ACCESS 2k I need to design a report based on a rota system for staff at various shops. The data is effectively stored in a single table, along the lines of: Initials (e.g. BH, FG, RM etc.)...
3
by: tod4 | last post by:
Hi I have a report with 3 subreports where from I take a few value in VBA On Print event. Some value causes error so i wrote in my procedure such code: On Error GoTo err_bl err_bl: If Err =...
3
by: Jer | last post by:
Using Access 2003 w/Windows XP. I have a database originally created with the tables internal. I split the database into a front-end/back-end with linked tables. Now when I open one of the...
2
by: AccessAl | last post by:
:confused: I have inheritted a system with reports that were probably written by a novice access programmer. My problem is a report with a dozen subreports in them. I had to add another subreport...
3
by: Wayne | last post by:
I have a report containing 2 subreports. The subreports each contain a chart. The whole thing easily fits on one page but a second blank page is consistently being generated. This has nothing...
2
by: kabradley | last post by:
Hello everyone. I have three reports that I would like to put into one main report. I tried creating the main report and then putting three seperate subreports in the detail section of the parent...
6
by: Brett Barry: Go Get Geek! | last post by:
Hello, I have a main report with a Record Source, a DateToday table, that has the current Month and Year. I have about 60 queries, each pulling different data via ODBC, that I am creating...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.