CODEWITHSUNDEEP
ms-accessreport
Steven
Steven

Reputation: 13769

MS Access Reports

I have a database of meetings. I can generate a report that sorts the actions by meeting but I would like to generate a separate report for each meeting. Any thoughts?

Upvotes: 0

Views: 137

Answers (2)

JohnFx
JohnFx

Reputation: 34909

If you want to report on all the meetings in one run, but get a separate report for each meeting you could add a grouping header on the Meeting and set that section of the report to do a page break before the that section.

Upvotes: 0

Matthew Groves
Matthew Groves

Reputation: 26141

You can write a Query in Access with a 'Where' clause that's set to something like [Enter the meeting number]. When running this query, Access will prompt for user input. Then you can set a report's data source to that query, so when running the report, Access will prompt for a meeting number (ID).

Alternatively, you could create a form with some sort of selection interface for the user to pick a meeting, dynamincally update the query, and run the report.

The first approach is easier, the second approach is more usable.

Upvotes: 2

Related Questions