Export from Report's recordsource

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to export the report's recordsource? I'm having to create many
reports with minor differences (such as sorting, limiting part number range,
etc ) in the criteria. In turn, I have to create various queries so that we
can export the results to Excel. If we can export the results of the report,
it will minimize the number of queries and reports. Thanks in advance.
 
You could use a form that sets the criteria and a QueryDef. (Look up
QueryDef in the Help file). A QueryDef programatically modifies a query
based on the criteria you select in the form. Doing it this way, all you
need is an additional form, one query and appropriate code.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)
 
Back
Top