Create Table from contents of a Report (1 Viewer)

[Elvis]

Hi All,

I am using Access 2007.

I have a report that is produced by running multiple queries. The report also has a number of calculated fields. I would like to save the contents of the report to a table.

Is there an easy way to save the contents of the report to a table. Something like export to table.

I know I can code the on-click or dbl-click event to extract the information from the report and create a table using VB, just wondered if there was an easy way to do it.

Thanks

 

[vbaInet]

You are reversing the process here and defeating the purpose of a report. A report is there to display data and nothing else. Secondly, calculated controls are not to be stored because if you make a change to a field that this calculation depends upon then you must update all records that depend upon the calculation. Furthermore, if you can calculate for everytime you need to see the figure why save it anyway?

Read this:

http://allenbrowne.com/casu-14.html