Ave,
I am trying to migrate a simple flat data set from Calc to Base. The
data describes individual financial operations, and what I got stuck
with is creating some kind of a summary sheet that after entering date
limits would list both all the operations within the defined period
and some statistics on them (like totals for different categories,
averages etc.).
This is my first encounter with Base and I don't really know in what
fashion to approach the task. I can imagine creating a form with
macros that would query the database and calculate the required
numbers, but this would require building the report by hand using
macros, and I get a feeling that there must be simpler ways...
(I thought of creating a query and then generating a report from it,
but it seems queries can return EITHER individual data OR aggregate
functions like sum or average - and then a limited set of those - but
more importantly they seem static, i.e. the limiting dates would have
to be entered in the query itself and not from a form).
Could somebody point me in the right direction, please?... :)
--
Andrzej Sawula
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
