Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Subreport - Limit to current report ContractID

Posted on 2014-03-07
2
Medium Priority
?
439 Views
Last Modified: 2014-03-07
I have a Main Report with a subreport that should display the totals for the current record only (contractID)  

I am using the Master/child link, however, the subreports seems to display all values.

I even tried limiting the query of the subreport using a variable - without success.

What is the best approach to display only those values on the subreport that matches the current record on the Mainreport?
0
Comment
Question by:Karen Schaefer
2 Comments
 
LVL 40

Accepted Solution

by:
PatHartman earned 2000 total points
ID: 39912964
The master/child links are used by Access to filter the contents of a subreport.  If they are not working, delete the subreport, save the report, compact and repair and then add the subreport back making sure to properly set the master/child links.
0
 

Author Closing Comment

by:Karen Schaefer
ID: 39912992
thanks that did the trick
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
Suggested Courses

783 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question