Export from Report's recordsource

S

Samantha

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.
 
S

Steve

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Images are pixelated when saving to PDF 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Possible to Combine reports to's to a single box? 0
Should I re-create criteria using form filter of just use the relevant query as recordsource? 2
Export Report to Excel not working? 0
DLookup Missing RecordSource Question 2
EXPORT DATA FROM A FORM TO EXCEL 2
two questions on exporting from a form 3

Top