Fighting with a summary field, again
Summary fields do not seem to be my thing. I'll start with the desired result then share what I have tried. I need to create a field that will contain all of the status for all of the orders associ...
Forum Discussion
I tried that approach, but there is nothing in that approach to group the combined text field by quote.
I may not have stated, the overall objective is a field that returns the unique statuses for all orders in a quote. Or more accurately, I am trying to find a way to determine when all of the orders in a quote are in a closed status.
If I created a separate table for quotes, used the quote as the key and created the combined text field in the new table, would that give me the results I need?
------------------------------
Paul Peterson
------------------------------
I may not have stated, the overall objective is a field that returns the unique statuses for all orders in a quote. Or more accurately, I am trying to find a way to determine when all of the orders in a quote are in a closed status.
If I created a separate table for quotes, used the quote as the key and created the combined text field in the new table, would that give me the results I need?
------------------------------
Paul Peterson
------------------------------
MarkShnier__You
Qrew Legend
Qrew LegendThis does not make sense.
I tried that approach, but there is nothing in that approach to group the combined text field by quote.
If this combined text summary field is on e Quote table, then all the combined status are for that single quote.
But if your real purpose is to know when all the orders have been close, why not just make a normal summary count of the number of Orders, and then make a summary count of the number of closed orders.
If the [# orders ] >0 and [# closed orders] = 0, then all orders are closed.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
I tried that approach, but there is nothing in that approach to group the combined text field by quote.
If this combined text summary field is on e Quote table, then all the combined status are for that single quote.
But if your real purpose is to know when all the orders have been close, why not just make a normal summary count of the number of Orders, and then make a summary count of the number of closed orders.
If the [# orders ] >0 and [# closed orders] = 0, then all orders are closed.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
- The tables are based on orders, not quotes. At the moment there is not a table of quotes.
------------------------------
Paul Peterson
------------------------------- MarkShnier__YouAh, then you need to have a table for Quotes. The Key field can be the Record ID# of if you have a system for manually entering a unique quote #, then that can be the Key field.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------