-
Oct 9th, 2017, 12:41 PM
#1
Thread Starter
Member
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
-
Oct 9th, 2017, 03:24 PM
#2
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
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|