Forum Discussion

RhondaJones's avatar
RhondaJones
Qrew Cadet
2 years ago

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
------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    2 years ago



    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
    ------------------------------
    • RhondaJones's avatar
      RhondaJones
      Qrew Cadet
      2 years ago

      that worked (minus the table reference). thank you!



      ------------------------------
      Rhonda Jones
      ------------------------------