Reports/Wizards/User to create

[Amy Adams via AccessMonster.com]

I am trying to brainstorm an effective way to let users create their own reports possibly without using the wizard (I have many tables and queries and the user would not know which to choose from), and also without saving the reports.

I could precreate reports for users, but they are hoping for so many different reporting scenarios that I would spend a week or more building them all.

I have read articles about drag and drop in access, I have also briefly looked into creating my own wizard "USysRegInfo."

I want to be able to let the users build reports on their own, but cannot think of a way to do this without the wizards, and without them ever having to see my tables/queries. Is it possible to build reports from forms?

Any advice?

 

[Duane Hookom]

Consider the Query By Form applet at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.

 

[Amy Adams via AccessMonster.com]

I am looking into this. Thanks so much, this may work :~)