gary,
As far as I can tell this is the way it works.
Unless you have a primary key on a table you cannot use functions on a
column in a query. The exception to this should be COUNT, if you have a
named range in your spreadsheet then you should see this function available.
I believe this is due to a design choice made in the HSQLDB engine and
not OO.o, per se, since Base is really just a wrapper around whichever
engine you choose to use. But my belief is based only on personal
observation, not any inside knowledge.
As for importing data from Calc into Base, well you could do that.
Either you would have to drag and drop the data or one could write a
macro that would import (update perhaps) a named range from a sheet into
a table. The macro should be pretty straightforward to write.
HTH
Andrew Jensen
[EMAIL PROTECTED] wrote:
When creating a query in design view (in Base):
While using a Calc spreadsheet (or a .dbf file) as the data source I
can't access functions such as sum etc. the drop down displays "no
function" as the only option.
Is this correct or am I doing something wrong?
How else would you sum groups of data in a query. Should I somehow
import the Calc data as a table in a Base document - as functions do
show up there.
Thanks in advance.
gary
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
