Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
# error in report calculated field
Sorry if I lost you..let me try to explain. PC_Summary is my main report. It runs off a query with all info on Product and claims pertaining to that product. In the header I have a subreport (PC_Shipped_Subreport). This is linked to the main report by product code. The subreport runs off a...- doe55
- Post #5
- Forum: Microsoft: Access Reports
-
# error in report calculated field
That didn't work. The subreport would have data on codes that did ship: Code 466 - 48 shipped, Code 999 - 0 shipped. Would my answer be just to run code 999 alone?- doe55
- Post #3
- Forum: Microsoft: Access Reports
-
# error in report calculated field
I have a report with several subreports. On the main report I have a field with the following calculation: =Sum([SumOfDIV_COST])/[Report]!PC_Shipped_subreport!SumOfSumOfQty_Shipped This calculates the average claim cost by how many items shipped. This works fine. Query parameters are pulled form...- doe55
- Thread
- Replies: 5
- Forum: Microsoft: Access Reports
