Creating a report

[Myple]

I need to create a report, this is what i want to do.
I need to create a report that is going to change. I want to beable to select fields on a report and create the report. I want to be able to change the report according to the fields i select. i.e lastname, first name, birthdate, age. next report might be last name, first name, Rank, date started work. If any one can help me with this I would appreciate it

 

[GoDawgs]

Not sure what you're asking...you can always make multiple reports...or a template that you use to design new reports. Let us know what you're looking for.

Kevin

 

[dhookom]

I have a custom report/query builder at

http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='DH Query By Form'

If the url doesn't work, go to

http://www.rogersaccesslibrary.com

and click on other developers. Find DH Query By Form.

Description:
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.


Duane
MS Access MVP