enduser reporting tool

[Ian Burton]

I have had a few requests for some sort of tool that end users can use to
create reports and query the database that isn't as complex as the access
front end. Does anyone have any recommendations or suggestions. Ideally I
would like to be able to integrate this into any access applications I
produce?
Thanks for your help,
Ian Burton

 

[Duane Hookom]

You might want to check out the DH Query By Form.
http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='DH Query By Form'

The DH QBF is a complete query by form applet that can be easily integrated
into any existing Access application. Typically, the functionality provided
by DH
QBF can replace many "canned" reports. The developer imports several forms
and
two tables from the DH_QBF.mdb, creates some master queries, and deploys.

The developer creates one or more master queries that join tables, alias
field
names, create calculated columns, etc. The users can then select a master
query
(datasource) from a drop-down and then select up to 30 fields from the
master
query. Users can define sorting and criteria as well as grouping and
totaling. All of
this "design" information is stored in two tables for re-use.

The results of the queries are displayed in a datasheet subform contained in
a main
form. The main form has options to send/export the records to print, Word
table,
Word merge, Excel, HTML, CSV, or a graph. Most formats allow the user to
automatically open the target application. The Word merge process will open
a new
Word document and link to the merge fields.