Subreports?? 1

[VAMick]

Ok, I don't do much Access programming, but a coworker need some reporting done.
I'd like to have one report output that would have a summary at the top by program areas summarizing the purchases for the month. Below that I need one of the program areas to have a detail listing of purchases, and then at the very bottom a grand total for all program areas.

Is this even possible to do with Access? I can't seem to find a way to do more than one report on a page, much less a summary and a detail (for one specific area) on the same page.

Thanks for any assist.

 

[dhookom]

Create a subreport "by program areas summarizing the purchases for the month". Place this subreport in your detailed report header.

The grand total might just be text boxes with sums or whatever.

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]

 

[VAMick]

What I'm not really understanding is, do I create two different queries for the report and the subreport?

And for the subreport that I upt in the detail header...is this going to show a detail for ALL areas or can I have it limited to just the one i need?

Thanks.

 

[dhookom]

Each report will have its own record source query based on what you want to display. You would normally set the criteria for the queries based on values a user enters into controls on a form.


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]