Sub-report filtering?????

[GJT]

Hi

I am using a sub report to list details of items that match the details on the main report. This works fine, I now need to minimise the results in my sub report by restricting the search to only display those items whose balance exceeds the qty count on the main report

ie. main report count is 50 therefore my subreport will only list those items whose count is greater than 50.

I thought a filter maybe the thing to use but it seems that reports do not utilise filtering like forms do.....

Any help with this would be greatly appreciated.

Thank you.

GJT

 

[Rich]

Try referencing the main report in the subreport's query criteria
ie >Reports!MyReport!MyField

 

[GJT]

Rich

Where exactly are these query parameters. I cannot find any on the properties dialog for the subreport......??????

The only references to the parent form are by way of the : Link Child / Master Fields, these are of course already linked. My search just needs refining......

 

[Rich]

Open the subReport on its own in design view, the record source should be either a query or the SQL, set the criteria there.

 

[GJT]

Of course - I should have known that!

Thanks for your help - works just as expected!