Saving fields, calculated in access report, to separate table

[mhegazy]

All,

I have created a report giving the reader full and summarized views of the daily data. The detailed section of this report is being summarized underneath the report in the footer section. What I need to do is to save the data off the textboxes of the summary section to a separate table. The table will be supposed to accommodate all the summaries of the month day by day, then based on this table, a simple query can be generated to get this data to be reported back as a monthly report.

Please see attached, a sample report.

Appreciate your help in this task.

Thanks to all in advance.

mhegazy

[jimatqsi]

mhegazy,
Reports should not create data or do updates, so you'll want to make a separate process. Can you create a query that produces the summarized data you want to save into a table? If you can do that, you want to create that as an append query.

You can use the append query to add data to the desired table. In the upper half of the query editor you can see there is a property (with properties turned on or right-click and then 'properties') for query type. Choose "append query" and then choose the output table. Each column of the query can be directed to be saved into a column of the output table.

Jim