Query Help
I am trying to create a query that searches a table for matching [Order] (fid 8) and then sums the field [Total Amount Claimed] (fid 250) from the found results. I haven't been able to get anything t...
Forum Discussion
Not tested, but try this
var text QUERY =
"{8.EX." & [Order] & "}";
SumValues(GetRecords($QUERY,[_DBID_MYTABLE]),250)
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
that worked (minus the table reference). thank you!
------------------------------
Rhonda Jones
------------------------------
