filtering results shown on report / subreports based on queries

[Emelina Bumsquash]

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?

 

[Allen Browne]

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

Reply to group, rather than allenbrowne at mvps dot org.

message
news:[email protected]...

 

[Emelina Bumsquash]

superb - the latter solution has worked for me perfectly. thanks loads!

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

Reply to group, rather than allenbrowne at mvps dot org.

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?