RhondaJones
2 years agoQrew Cadet
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...
Not tested, but try this
var text QUERY =
"{8.EX." & [Order] & "}";
SumValues(GetRecords($QUERY,[_DBID_MYTABLE]),250)
that worked (minus the table reference). thank you!