Saving data in report to table

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

Guest

Hi all,

I need to store some data that I've generated on my report together with data retrieved from the recordsource into a table for future references. Please advise me on how this can be done.

I've tried to insert the record into my table on Report Close.. but only the record after my active record is inserted into the table.

Thanks!
 
You don't store the data from the report... but your purpose may be served
by storing the data from the report's RecordSource query.

Write an append query that uses the report's query to copy the data into the
table. If your report has textboxes that calculate results outside the
query, then you'll need to add calculated fields (or a different query) to
do those calculations.

--

Ken Snell
<MS ACCESS MVP>

yann said:
Hi all,

I need to store some data that I've generated on my report together with
Click to expand...
data retrieved from the recordsource into a table for future references.
Please advise me on how this can be done.
I've tried to insert the record into my table on Report Close.. but only
Click to expand...
the record after my active record is inserted into the table.
 
Back
Top