Access Reporting - Hammer
Category: Computers > Programming
Asked by: bselltiz-ga
List Price: $5.00
05 May 2003 09:56 PDT
Expires: 04 Jun 2003 09:56 PDT
Question ID: 199657
I need to sort a report based upon user input from a form. The form has a custom list of names corresponding to field names in the report's recordsource. The user chooses a name then either ascending or descending and then clicks print. The problem is that I can not put the report into design view since this will be for an application being run as an mde. Thanks, Brian
Re: Access Reporting - Hammer
Answered By: hammer-ga on 05 May 2003 10:56 PDT
Brian, In cases where just changing the WHERE clause won't do it for you, you can build the recordset on which you want the report based in runtime, giving you complete control over it. Detailed instructions and sample code can be found in an MVPS Access FAQ topic. MVPS Access FAQ Use a recordset as report's datasource http://www.mvps.org/access/reports/rpt0014.htm - Hammer
rated this answer:
Hammer getting me what I need as usual :-> Thanks!
|There are no comments at this time.|
If you feel that you have found inappropriate content, please let us know by emailing us at firstname.lastname@example.org with the question ID listed above. Thank you.
|Search Google Answers for|