Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Base: run query on connected spreadsheet?

Howdy,

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?

Base: run query on connected spreadsheet?

Howdy,

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?