performing count function in openoffice base

Performing count function in openoffice base how to#
Performing count function in openoffice base software#
Performing count function in openoffice base download#

That's the sort of data we will work with. a subset of 'subset', in fact! (All towns in the four states with populations (2010 census) between 29,000 and 33,000. in some contexts, SQL (and thus Open Office's database) use 'between' to mean 'between and including'. The subset lists all of the towns with populations between 29,999 and 40,000. Otherwise, the figures and tables in this essay would have become much too long. but it suited my purposes to have it available. If you wanted the subset, you would generate it with a query. You would not normally have such a table in a database. It is a clone of part of the larger table. but the basic table is already there.Īlso in the database. If you do it on 26 Oct 12, it may well be incomplete, as I am still writing this tutoria1!.

Performing count function in openoffice base download#

You can download that database with town populations and a few stray other facts, zipped up with a ReadMe text file. every town in those states with a population of more than 29,999, that is. I harvested records for every town in Massachusetts, Connecticut, Vermont and New York. A database to 'play' with.Īs ever, a little grist for the mill will be helpful.įor this tutorial, I went off to Wikipedia and collected some data about towns in the US. If your mind wanders, and you start thinking about screws, before long, you'll be imagining driving screws with the hammer. Suppose you were learning about carpentry, and the instructor was talking about what a hammer can do.

Performing count function in openoffice base software#

Just concentrate on 'What can the database software do?' It is very easy to let your mind drift, and imagine that the software will do things you might want it to do, even though it doesn't do that, and thus distract yourself from what you are supposed to be learning about what it actually can do.Ĭontinuing with that. To return to my thought of 'concentrate on what it is designed to do.'.įor a moment, try not to think too much about what you would use the functions and grouping tools for.

Performing count function in openoffice base how to#

and even have some idea of how to do them! Once you have learned the capabilities provided they provide, you may start realizing things that you now want to do with a database. In this essay, I am going to show you those functions in action. Page contents © TK Boyd, Sheepdog Software, 10/12.

(Enlarge, reduce, restore to default, respectively.) (This is fully explained, and there are more tips, at my Power Browsing page.) With most browsers, pressing plus, minus or zero while the control key (ctrl) is held down will change the texts size. Make your browser window as wide as you want it. There's more about ooBase in the main index to this material. And making things easy for users on different platforms. and saving million$, but still Getting The Job Done. Big organizations, governmental and civilian, have adopted it as their standard office suite. Remember that Open Office, including ooBase, is free. You may find that the database included in OpenOffice delights you as much as it has me. Grouping, and functions acting on grouped data In Open Office's database, 'Base'