Create auto reports (1 Viewer)

I have a database that is used for requests for information.
I have dates dd/mm/yyyy and a drop down that looks at the diffrent organsisations they want the information from.

Is there a way that I can get a seperate report for each organisation that looks at the table "organisations" and automatically creates a report that will display last months requests?

Thanks DAN

You may get some ideas here
http://www.fontstuff.com/access/acctut19.htm