By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,628 Members | 1,880 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,628 IT Pros & Developers. It's quick & easy.

Saving fields, calculated in access report, to separate table

P: 19
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
Attached Files
File Type: pdf DailyReport.pdf (394.7 KB, 220 views)
Jun 2 '14 #1
Share this Question
Share on Google+
1 Reply


Expert 100+
P: 1,240
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
Jun 2 '14 #2

Post your reply

Sign in to post your reply or Sign up for a free account.