I created a a Base database that links to a huge .ods spreadsheet of weather data organized into date, time, and temperature fields. The link works fine and creates a properly formatted table in which I can see all the data.
The problem occurs when I try to run a query on the table. I want to display the maximum daily temperatures. So I add the date and temp fields to the query. But when I try to access the GROUP or MAXIMUM functions in the drop-down menu, I find the drop-down menu is empty. In fact, there are no functions available in queries at all.
Am I doing something wrong, or is this a limitation of connected databases in Base?
Is there a work-around?