Summary Report Help
I'm trying to build a report, I've tried several different options, and not getting the result I need. I have a tablet with the following data/fields, that I'm trying to get an end result for. We ...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendI am just guessing as to the structure of your app but it seems to me the proper structure would be to have a relationship between your two tables. There would be a table of Fund Categories and a table of Amounts spent.
Then you would have a Relationship where One Fund Category has many Amount Spent entries.
Then on that relationship you would make a summary field to total update about spent. That way each Fund category would know how much has been spent so far. had a data entry field on the fund category where you could enter the opening balance for the fund category then you would know how much is remaining to spend by subtracting.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
mark.shnier@gmail.com
------------------------------
Then you would have a Relationship where One Fund Category has many Amount Spent entries.
Then on that relationship you would make a summary field to total update about spent. That way each Fund category would know how much has been spent so far. had a data entry field on the fund category where you could enter the opening balance for the fund category then you would know how much is remaining to spend by subtracting.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
mark.shnier@gmail.com
------------------------------
- Thank you that is very helpful. It worked perfect.
------------------------------
Neal Neal
------------------------------
