Hi I am trying to use ExecuteSQL to perform a simple sum of record in a table and clearly I cannot seem to get it to work so I am missing something basic
So I have a field in a table called total_qty_received
I have another table name po_item_receipts that has a number field names po_qty_received
I would like to sum of the po_qty_received and store it in the first table in the field total_qty_received
I have tried a number of formats from the forum but non seem to work for me
ExecuteSQL ("Sum po_qty_received from po_item_receipts" ;"" ; "")
once I get the above to work I would like to add some selection criteria
Were PO_number = $Po_Number and part_number = $Part_Number
I would like to SQL expression to be stored in a calculated field so that it updates automatically.
any assistance would be much appreciated.