Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Subreport - Limit to current report ContractID

Posted on 2014-03-07
2
Medium Priority
?
437 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
[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 Comments
 
LVL 39

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

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

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.
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

688 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