Dynamiic report

[Bob500]

Hi,

I would like to run a report that the criteria for is selectable from a variety of tickboxes.

i.e All the fields are available as tickboxes and the user selects those that they require the information about, there will then be a 'run report' button that will then gather the selected criteria and compile a report.

Any ideas or locations of tutorials?

Cheers.

 

[dhookom]

If this doesn't have to be a published report, consider the Query By Form applet in the Corp Tech Demos at

http://www.invisibleinc.com/divFiles.cfm?divDivID=4.

Users can select up to 30 fields, set criteria, and apply a sort order. The results are displayed in a datasheet subform with buttons to send the results to print, Word Table, html, csv, Excel... All "report" definitions are saved in a couple tables so they can easily be recalled, modified, and run.

Duane
MS Access MVP