Hey Guys,Is it possible to take a text box calculated value from a report and append it to a field in a table?Basically what I have is a report with a list of values. At the end of the report I have a sum of the values. I want to take this sum and append it to a field in my tableFor example:Values1234Total: 10In my table I have tags and values:Tag ValueT1 10T2 0T3 0So I want the ability to take the summed value from the report and append it to my table as shown above. Hope that makes sense, Thanks guys.

MiltonPurdy

Oct 19 2011, 02:25 PM

No.uild a query, sum your data there and then append it.

byronMills

Oct 19 2011, 02:27 PM

Alright, Thanks

GroverParkGeorge

Oct 19 2011, 02:28 PM

As a general rule, storing calculated values is a bad design. Therefore, while it is possible to do this, it is probably not a good idea to do it.If you can count the values in the report, you can also count them in a query, as Milton suggested. And because you can count them ANYTIME you need to do so in that same query, it would be redundant to store that count in a table. Anytime you want to show the count, do so with that query.

This is a "lo-fi" version of UA. To view the full version with more information, formatting and images, please click here.