Multiple Reports

[Guest]

In Access 2000-2003 I have built the tables and an input form, and now there
are approximately 13 reports they want to generate from this data. I know I
can set up access to them via a switchboard , but is there any other way that
may be more efficient to allow access to these reports? In addition, I will
have to set up some sort of a ?query? for the user to input the range
(usually date) to determine the data to incorporate into the reports. I'm
really not too familiar with reports and I feel like I'm in over my head on
this one!! Any help will be greatly appreciated!

Owl Lover

 

[Guest]

I have found using a listbox to list the report and allowing the users to 2x
click on them to open them works well. Avoids the switchboard, adding
buttons for each new report...

as for date ranges... You can base you report on a query instead of a tbl
and then setup a criteria for the field in question which uses value taken
from a form. the user select a date (date range) and open the filetered
report.

 

[Guest]

Owl Lover,

An example of a form that allows a user to specify criteria, as Daniel
indicates, is available for download from my personal web site:

http://home.comcast.net/~tutorme2/samples/customdialogbox.zip


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________