I have a fairly simple query that works in the data viewer but will not work on a layout showing only "?".
"line_cost" is a calc field with qty x cost. qty and cost are indexed.
I am using "SELECT SUM( line_cost ) FROM TableA". This works in data viewer but never on a layout. Any ideas?