bill purvis wrote:
Hi,
I'd like to use Calc as a simple database. I've had a go with OOo.Base
and couldn't do what I wanted there and wondered if it was possible
with Calc. My data is very simple - it started out as a simple
spreadsheet anyway. What I want to do is have several sheets which
present filtered versions of the main sheet. I believe that Filters
can achieve the end result, but I'd like to just switch between the
'full' view and a 'filtered' view by clicking on the Sheet tabs.
Any changes to the 'full' sheet should be reflected in the 'filtered'
sheet(s).
Is this sort of thing possible?
The data is just a list of membership details.
One example would be to have a sheet showing all UK members,
and another showing non-UK members.
There is a column in the data which contgains the country if non-UK
and is blank for UK members.
Many thanks
Bill
Hi Bill,
You can get help the document presented, but what I am interested in how
as you say you could not do this in Base?
As this is my curiosity here if you would rather not go into it that is
fine but the ability to form subsets of data like this is one of the
core abilities of a query.
Thanks
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
