General query and reporting mechanism

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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/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,...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

General query and reporting facility 1
Cross Tab Report Vs Dynamic coulmns 0
Can't create a report from my query in Access 1
Access Access Report Works on One Machine but not Another 3
Report based on Crosstab Query 3
Tabular Report that looks up row header and column header for query parameters 1
access 07 report/design view/from query 2
CrossTab Query Access Report - 1

Back
Top