By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
 434,917 Members | 1,313 Online
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,917 IT Pros & Developers. It's quick & easy.

# Error in grandtotal for the Main Report containing subreports

 P: 66 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
Share this Question
7 Replies

 Expert Mod 10K+ P: 14,534 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

 P: 66 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

 Expert Mod 10K+ P: 14,534 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

 Expert Mod 15k+ P: 31,492 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

 P: 66 datatype is set to numeric..but still getting the error Jan 11 '10 #6

 Expert Mod 15k+ P: 31,492 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

 P: 66 i m really very sorry...I wil surely b writing in detail for any of my queries further.... Jan 12 '10 #8

### Post your reply

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