Allowing Users to Customize Report Fields?

[firebirdta84]

Hi,

I have a table containing about 35 different fields. I'd like to be able to have the user choose X number of fields from those 35 (maybe via a drop down box) and display a report on just those fields they choose. First, is this possible and can someone steer me in the right direction?

Thanks,
Joe

 

[dhookom]

You might want to try the Query By Form found at

http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane

which allows users to create ad-hoc reports.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]