If you remove just the Sum(), do you get one result per state?
What is the field definition for GrandTotal?
I have tried that but it gives me separate totals for each invoice. I am trying to get the total of all invoices by state for given date range
Grand Total is just the invoice total.
"SELECT ST_State, Sum ( GrandTotal )
GROUP BY ST_State
ORDER BY ST_State " ;
"" ; "" ;
All non-aggregated column references in the SELECT list and HAVING clause must be in the GROUP BY clause.
Orders.fmp12.zip 12.7 K
I can't believe i didn't try that!
I would thank you by name but not sure who you are...