General query and reporting mechanism

M

mscertified

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.
 
D

Duane Hookom

There is a fairly comprehensive reporting/querying "applet" at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#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,...
 
Top