Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.
Course Of The Month
10 days, 4 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Trying to sum the value of a number field on a main report and the value of a number field on a subreport
Posted on 2014-02-11
I'm rrying to sum the value of a number field on a main report and the value of a number field on a subreport that is in the main report.
Here is what I have but it doesn't work:
=[txtRegHrs]+[Reports]![su
Here is what I have but it doesn't work:
=[txtRegHrs]+[Reports]
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
-
2
4 Comments
Active 6 days ago
Hi,
Place the controls in the report footer and subreport footer
=Sum(txtRegHrs]) <-Sub Report name control txtTotalSub
=Sum(txtRegHrs]) + [subrptTimeCardDataEntryCo
note that [subrptTimeCardDataEntryCo
regards,
Bill
Place the controls in the report footer and subreport footer
=Sum(txtRegHrs]) <-Sub Report name control txtTotalSub
=Sum(txtRegHrs]) + [subrptTimeCardDataEntryCo
note that [subrptTimeCardDataEntryCo
regards,
Bill
Active today
Since a subreport can have multiple rows, exactly which row did you want to reference?
What I would do is create a totals query that sums to the level I need. Then since this is a report, I can change my RecordSource query to join to the totals query which will let me bind a column to the total. Then my expression would be
=Nz(txtRegHrs,0) + Nz(SumRegHrs,0)
What I would do is create a totals query that sums to the level I need. Then since this is a report, I can change my RecordSource query to join to the totals query which will let me bind a column to the total. Then my expression would be
=Nz(txtRegHrs,0) + Nz(SumRegHrs,0)
Active today
I'm trying to reference this in the field in the footer of the main report...
txtGroupRegHrsTotal
and in the subreport I'm trying to reference this in the footer of the sub-report...
txtCostCtrGroupRegHrsTotal
Here is what I have but still not working.
=Sum([txtGroupRegHrsTotal]
txtGroupRegHrsTotal
and in the subreport I'm trying to reference this in the footer of the sub-report...
txtCostCtrGroupRegHrsTotal
Here is what I have but still not working.
=Sum([txtGroupRegHrsTotal]
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
AutoNumbers should increment automatically, without duplicates. But sometimes something goes wrong, and the next AutoNumber value is a duplicate. This article shows how to recover from this problem.
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database.
Split up all multi-value fields into single values:
Split up fields that belong to other things into separate tables:
Make sure that all record…
Suggested Courses
Earn Certification
HTML5 Specialist - Certification
Free withPremium
Course of the Month10 days, 4 hours left to enroll
623 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.