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------------------------------
Original Message:
Sent: 03-11-2023 20:11
From: Rhonda Jones
Subject: 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 to work and wonder if it is because neither are manual entry fields. Order is rich text formula field and Total Amount Claimed is a formula currency field.
Any help would be appreciated.
------------------------------
Rhonda Jones
------------------------------