Trouble pulling data

  • 0
  • 1
  • Question
  • Updated 6 months ago
  • Answered
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.
Photo of Ya'akov Goldberg

Ya'akov Goldberg

  • 210 Points 100 badge 2x thumb

Posted 6 months ago

  • 0
  • 1
I read this twice but have no idea what your need us.

Can you try to better explain what you need here. Maybe use an example? I’m lost.
Photo of Ya'akov Goldberg

Ya'akov Goldberg

  • 210 Points 100 badge 2x thumb
Thank you for your offer to help, and sorry for the confusion on the message, however, we realized that we are actually doing the process in question backward. 
okidoki