JakeRattner1
3 years agoQrew Cadet
Formula Queries - Finding Min/Max of Value Using Foreign Key in Other Table
Hi QB Community,
I'm excited about the new Formula Query and am trying to use it to find the minimum and max fields in a seperate table.
I start with this:
GetFieldValues(GetRecords("{249.EX.'"& [StateID] &"'}", "DBID"), 212)
In the query, I'm returning a text list that shows all the 'prices' (fid212), where the 'stateID' (fid249) matches the 'StateID' on the record. This part works.
Now I'm trying to figure out for to derive the min and/or max from the resulting text list.
I've used SearchAndReplace to modify the text list in a few different ways to that I can pass it into the Max function, but no luck yet.
Do you konw how to do this?? Thanks!
------------------------------
Jake
------------------------------
I'm excited about the new Formula Query and am trying to use it to find the minimum and max fields in a seperate table.
I start with this:
GetFieldValues(GetRecords("{249.EX.'"& [StateID] &"'}", "DBID"), 212)
In the query, I'm returning a text list that shows all the 'prices' (fid212), where the 'stateID' (fid249) matches the 'StateID' on the record. This part works.
Now I'm trying to figure out for to derive the min and/or max from the resulting text list.
I've used SearchAndReplace to modify the text list in a few different ways to that I can pass it into the Max function, but no luck yet.
Do you konw how to do this?? Thanks!
------------------------------
Jake
------------------------------