Developing a Report

[nwyork]

I have a query form I created, and I want to generate a report from this. I'm trying to think of way of allowing the client select what columns with checkboxes that he or she wants to see on the report. I have few ideas, but I feel there is a more efficient way of doing this. Any help would be appreicated.

Thanks ahead of time
Nick

 

[PaulTEG]

You can build your query from checkboxes, pay attention to date ranges, and include most common on one form, and allow for an advanced search capability in a second form.

You could have 'here's one I prepared earlier' queries in a drop down, and let the user name the report, like "aged debtors 30", "aged debtors 60", "aged debtors 90", etc

And if the drop down isn't selected proceed with the check box selection

HTH
--Paul

Nancy Griffith - songstress extraordinaire,
and composer of the snipers anthem "From a distance ...