Trouble pulling data
This is a complicated one, and I want to start by saying that we are trying to avoid code, formulas are ok, but we do not want to put in any IOL sections or anything of that sort.
We have a table that the purpose of it is to be one spot that is a report for another table. It is setup that the user selects the specific week, then manually enters in the data for that week. The data is how many consumers(a table with their data) we had that were set to active (this is from a multiple choice list). The trouble is that that value can change at any time, so just a normal report will not work, as we want the total number of consumers that were active during that week to never change. As well, we cannot create a relationship between the two tables and just created a total number of records field because the "report table" gets created after the fact, and nobody will go back through and connect all of the "consumer table" records to the appropriate "report table" record.
We have a table that the purpose of it is to be one spot that is a report for another table. It is setup that the user selects the specific week, then manually enters in the data for that week. The data is how many consumers(a table with their data) we had that were set to active (this is from a multiple choice list). The trouble is that that value can change at any time, so just a normal report will not work, as we want the total number of consumers that were active during that week to never change. As well, we cannot create a relationship between the two tables and just created a total number of records field because the "report table" gets created after the fact, and nobody will go back through and connect all of the "consumer table" records to the appropriate "report table" record.
