Discussions

 View Only
  • 1.  Query Help

    Posted 03-11-2023 20:11

    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
    ------------------------------


  • 2.  RE: Query Help

    Posted 03-11-2023 21:21



    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
    ------------------------------



  • 3.  RE: Query Help

    Posted 03-12-2023 09:36

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



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