how does one functions in the query design view in LibreOffice BASE (NOT in SQL)
The functions onesee in the menu (at the grid) in the query design view are:
Average
Count
Maximum
Minimum
Sum
Every
Any
Some
STDDEV_POP
STDDEV_SAMP
VAR_SAMP
VAR_POP
Collect
Fusion
Intersection
Group
Example I want a count of “Afrd IDX”
I click the funtion square and pick Count.
That is all I can do.
Error message is “Not in aggregate function or group by clause:”
Okay, now what?
Is it possible to use functions in Design View?