Customized report based on user input.

[Guest]

Hello all,
Basically I have a table which contains:

Last Name
First Name
Middle Name
Rank
SSN

I want to create a form which presents the user with the option for which items to print in a report. Basically, choose Last Name, First Name, and SSN or Last Name, First Name, and Middle Name or etc.

I've tried everything from queries to forms and haven't been able to figure this one out. I've even tried the "Customize report based on user selections in a form" instructions on one of the posts here.

Any help is appreciated.

Thanks,

Gary

 

[Duane Hookom]

You might want to consider the Query By Form applet at
http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='DH Query By Form'
***FEATURES***
An all Access mail merge feature was added Mar 6, 2004. This allows users to
create simple mailmerge output without using a word processing program such
as
MS Word.

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,
tables, a query, and a report 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, Merge to Report, or a graph. Most formats
allow
he user to automatically open the target application. The Word merge process
will
open a new Word document and link to the merge fields.


--
Duane Hookom
MS Access MVP

Hello all,
Basically I have a table which contains:

Last Name
First Name
Middle Name
Rank
SSN

I want to create a form which presents the user with the option for which

items to print in a report. Basically, choose Last Name, First Name, and
SSN or Last Name, First Name, and Middle Name or etc.

I've tried everything from queries to forms and haven't been able to

figure this one out. I've even tried the "Customize report based on user
selections in a form" instructions on one of the posts here.