Creating a query that will create a table...

[AjilonSS]

I have a report with sub reports. I currently have a table with a query that filters a specific field. How do I go about creating another query filter to create a table in the report sub reports?

Instead of me manually entering 25 new tables (sub reports), how can I create a query to filter the sub reports and turn it into a table?

Is this possible?

 

[dhookom]

AjilonSS,
Please don't ask the same question in multiple forums. There is at least one response in the query or report forum where you asked this same question.

Duane
MS Access MVP
[green]Ask a great question, get a great answer.[/green]
[red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]
[blue]Ask me about my grandson, get a grand answer.[/blue]