Error in grandtotal for the Main Report containing subreports

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • shalskedar
    New Member
    • Sep 2009
    • 66
    #1

    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???
    Tags: None
    • MMcCarthy
      Recognized Expert MVP
      • Aug 2006
      • 14387
      #2
      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.

        Comment

        • shalskedar
          New Member
          • Sep 2009
          • 66
          #3
          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

            Comment

            • MMcCarthy
              Recognized Expert MVP
              • Aug 2006
              • 14387
              #4
              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.

                Comment

                • NeoPa
                  Recognized Expert Moderator MVP
                  • Oct 2006
                  • 32633
                  #5
                  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.

                    Comment

                    • shalskedar
                      New Member
                      • Sep 2009
                      • 66
                      #6
                      datatype is set to numeric..but still getting the error

                        Comment

                        • NeoPa
                          Recognized Expert Moderator MVP
                          • Oct 2006
                          • 32633
                          #7
                          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.

                            Comment

                            • shalskedar
                              New Member
                              • Sep 2009
                              • 66
                              #8
                              i m really very sorry...I wil surely b writing in detail for any of my queries further....

                                Comment

                                Previous template Next
                                Working...