I´m trying to calculate the total value of the items in my stock using Execute SQL with the sentence underneath, but filemaker doesnt recognize it.
SELECT DISTINCT Item_ID , SUM (stock_value)
where Date_field < ?
" ; "" ; "" ; g_date)
i only can make it working without the SUM, but then formatting the text is a nightmare.