Selecting fields for subreports

[Billstopay]

I have many subreports that make up one main report that is not linked. How can I select which fields display for all of the sub reports when the main report is printed?

It is currently part of the query that makes up each sub report, but I need to make it possible to just input the criteria once when the report is run so it doesn't pop up as many times as I have queries/Subreports.

P.S. This site is great - probably saved my job already!
Thank you thank you thank you

 

[Billstopay]

OOPS - I meant rows

 

[dhookom]

I'm glad you meant rows and not fields. IMHO, you shouldn't use parameter prompts in queries. Consider reviewing this FAQ faq701-6763.

Duane MS Access MVP
Now help me support United Cerebral Palsy

 

[Billstopay]

Thanks - I am still in the design phase of the whole project so that is something to think about. I am coming into a database system that someone else created, 50 tables, probably 300 queries that use any combination of the tables, and they want me to product one report that shows the results of approx 75 of the queries at a time. No forms are currently used, we go straight from raw data to the report through the existing queries which are selected on such fields as "county" or "district". (They used to export the data to excel one query at a time, then format)

Sub reports seems to be my only option...but willing to investigate any and all avenues to find the best way before I start.

 

[dhookom]

results of approx 75 of the queries" and "No forms are currently used" wow! I can't imagine creating an Access application without users navigating and interacting with data through forms.

FWIW: I don't know anything about your system but I find a lot of Access systems put together by non-programmers where multiple queries are created that should be only one.

Duane MS Access MVP
Now help me support United Cerebral Palsy