If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
filtering results shown on report / subreports based on queries
Hi all, i can't find anything similar to my question already posted (or at
least anything that i can understand!) so any help would be really appreciated - considering i have never used report filters before. due to access field limitations, i have had to do multiple simple queries to get the data i'm interested in. i want to have all this data on a report so i've had to do it using various subreports so that all the queries are in the same place. all the queries include the same primay key 'studynumber' in their results. what i'd like to do is have a dialogue box or something that pops up when you try to open the report which will mean all the subreports (based on the various queries) will all return ONLY the results from a specific study number. any suggestions? |
#2
|
|||
|
|||
filtering results shown on report / subreports based on queries
1. Open the main report in design view.
2. Right-click the edge of the subreport control, and choose Properties. 3. Add the studynumber field to the Link Master Fields and Link Child Fields properties (on the Data tab of the Properties box, when looking at the properties of the subreport control.) For example, if they currently read: ID change it to: ID; studynumber An alternative approach would be to create a form with an unbound text box where the user can enter the StudyNumber they want. Then refer to this text box in the Criteria of both the main report's query and the subreport's query, e.g.: [Forms].[Form1].[txtStudyNumber] -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Emelina Bumsquash" wrote in message ... Hi all, i can't find anything similar to my question already posted (or at least anything that i can understand!) so any help would be really appreciated - considering i have never used report filters before. due to access field limitations, i have had to do multiple simple queries to get the data i'm interested in. i want to have all this data on a report so i've had to do it using various subreports so that all the queries are in the same place. all the queries include the same primay key 'studynumber' in their results. what i'd like to do is have a dialogue box or something that pops up when you try to open the report which will mean all the subreports (based on the various queries) will all return ONLY the results from a specific study number. any suggestions? |
#3
|
|||
|
|||
filtering results shown on report / subreports based on querie
superb - the latter solution has worked for me perfectly. thanks loads!
"Allen Browne" wrote: 1. Open the main report in design view. 2. Right-click the edge of the subreport control, and choose Properties. 3. Add the studynumber field to the Link Master Fields and Link Child Fields properties (on the Data tab of the Properties box, when looking at the properties of the subreport control.) For example, if they currently read: ID change it to: ID; studynumber An alternative approach would be to create a form with an unbound text box where the user can enter the StudyNumber they want. Then refer to this text box in the Criteria of both the main report's query and the subreport's query, e.g.: [Forms].[Form1].[txtStudyNumber] -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Emelina Bumsquash" wrote in message ... Hi all, i can't find anything similar to my question already posted (or at least anything that i can understand!) so any help would be really appreciated - considering i have never used report filters before. due to access field limitations, i have had to do multiple simple queries to get the data i'm interested in. i want to have all this data on a report so i've had to do it using various subreports so that all the queries are in the same place. all the queries include the same primay key 'studynumber' in their results. what i'd like to do is have a dialogue box or something that pops up when you try to open the report which will mean all the subreports (based on the various queries) will all return ONLY the results from a specific study number. any suggestions? |
Thread Tools | |
Display Modes | |
|
|