On Sunday 02 December 2007, Drew Jensen wrote: > 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 Drew, I upgraded my OOo to 2.3 and found it still would not allow me to sort the data in the way I wanted in a query. If you recall, I was trying to sort by surname, then first name but show the first name before the surname. Even after updating it still refused to turn off the visible flag if sorting was enabled. What's the point of the visible flag if you can't turn it off?
Bill -- +---------------------------------------+ | Bill Purvis, Amateur Mathematician | | email: [EMAIL PROTECTED] | | http://bil.members.beeb.net | +---------------------------------------+ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
