generating a report based on fields

[norm]

Creating a select field parameter for a report,

Is this possible in access? I have a table that has the following fields:

Veh
Year
Make
Model
Color
Dealer
Repair Location
Price
Class Code
Driver
is it possible to have one report, that will give me the option of choosing
the fields I want displayed? or do I have to create a different report for
each of the combinations I need?

 

[Al Campagna]

Norm,
It's do-able.
Create a dialog form with check boxes for every field in the report.
The report, when run will look to the open form to see what fields are
checked, and hide any that aren't.
(probably using the OnFormat event of the appropriate report section)
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."