Expand all | Collapse all

Trouble pulling data

  • 1.  Trouble pulling data

    Posted 01-02-2019 20:28
    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.

  • 2.  RE: Trouble pulling data

    Posted 01-03-2019 04:36
    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.

  • 3.  RE: Trouble pulling data

    Posted 01-04-2019 20:28
    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. 

  • 4.  RE: Trouble pulling data

    Posted 01-04-2019 20:40