General query and reporting mechanism

Has anyone written a general query and reporting mechanism in Access?
By this I mean a system where the user chooses a table or tables and the
columns of interest, specifies control breaks and the Access program itself
writes and runs the report dynamically.
Any pointers on doing this would be appreciated.

There is a fairly comprehensive reporting/querying "applet" at
http://www.rogersaccesslibrary.com/O...p#Hookom,Duane. The
developer imports several generic forms, tables,... from the sample and then
creates 1 or more datasource queries. A datasource query is a standard query
that combines one or more tables with the appropriate joins and column
aliases (make your records fit for user consumption).

The query definitions are stored in a couple tables for recalling, modifying
and running. Results are displayed in a datasheet subform with a couple
clicks to sending to printer, HTML, CSV, text, Excel, Word Table or
Merge,...

--
Duane Hookom
MS Access MVP
--

"mscertified" wrote in message
...
Has anyone written a general query and reporting mechanism in Access?
By this I mean a system where the user chooses a table or tables and the
columns of interest, specifies control breaks and the Access program
itself
writes and runs the report dynamically.
Any pointers on doing this would be appreciated.