Results 1 to 2 of 2

Thread: MS Access Report Calculations - #error and #Type! In Preview Mode

  1. #1

    Thread Starter
    Member
    Join Date
    Oct 2008
    Posts
    46

    MS Access Report Calculations - #error and #Type! In Preview Mode

    I'm working on an Access 2013 Change Order report.

    The Details section contains 4 sub reports, Labor, Hardware, Lumber, and Equipment. Each of the four sub-reports is designed the same - A detail line and in the footer is a sum() calculation.

    Then, in the Main Report, I total up all sub-report totals. There one one total line for each of the four sub-reports, and each of the references a sub report total field, as in

    Code:
    =[rptChangeOrders_Labor_Details].[Report]![txtLaborTotal]
    =[rptChangeOrders_Hwr_Details].[Report]![txtHardwareTotal]
    =[rptChangeOrders_Equipment_Details].[Report]![EquipmentTotal]
    =[rptChangeOrders_Lumber_Details].[Report]![LumberTotal]
    Each of these refers to a total field contained in the footer of a sub report.

    When I run the report I see the totals field as you would expect it. See this pic .

    In some Change Orders not all sub reports have data. When I run those they look fine also. See this. Again, looks fine.

    But, when I select Print Preview, I get this.

    I have been trying to figure this out for days. Googling #error and #type! doesn't give me a concrete reason as to what's wrong. Can anyone shed some light here?

    Thanks

  2. #2
    Don't Panic! Ecniv's Avatar
    Join Date
    Nov 2000
    Location
    Amsterdam...
    Posts
    5,343

    Re: MS Access Report Calculations - #error and #Type! In Preview Mode

    In some Change Orders not all sub reports have data
    Thats your problem there. You need to IIF or NZ them to change them from null/nothing to 0

    BOFH Now, BOFH Past, Information on duplicates

    Feeling like a fly on the inside of a closed window (Thunk!)
    If I post a lot, it is because I am bored at work! ;D Or stuck...
    * Anything I post can be only my opinion. Advice etc is up to you to persue...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width