The PivotTable Wizard can assist you in creating a pivot table from an external source such as an Access, FoxPro, or SQL Server database. With Microsoft Query installed on your computer, the PivotTable Wizard will load Microsoft Query so that you can create a result set for the data you want to analyze.

The most common source for pivot tables is an Excel list. Just about any list can be made into a pivot table, however, the list should have the following characteristics: least one field, and best if it's two or three fields, that is "groupable" in that the field contains a limited number of distinct data (text, numbers, or dates) Shortcut: You can also access the PivotTable Wizard using the PivotTable Wizard button on the Query and Pivot toolbar. See similar questions...

A pivot table is a powerful tool which allows you to roll up, filter and sort structured data along any of the dimensions or axis which define your numbers. See similar questions...

Usually you will want to turn off the row and column grand totals otherwise they will distort the chart. In Excel 97 all you then need to do is to click on a cell anywhere within the pivot table, and then run the chart wizard. With earlier versions of Excel you will need to select the area yourself. See similar questions...

Of course, these are not actually unlimited, but limited to available disk space and memory/swap space. Performance may suffer when these values get unusually large. The maximum table size of 32 TB does not require large file support from the operating system. Large tables are stored as multiple 1 GB files so file system size limits are not important. The maximum table size, row size, and maximum number of columns can be quadrupled by increasing the default block size to 32k. See similar questions...

A database table is a basic unit of data logical storage in an Oracle database. Data is stored in rows and columns. You define a table with a table name, such as employees, and a set of columns. You give each column a column name, such as employee_id, last_name, and job_id; a datatype, such as VARCHAR2, DATE, or NUMBER; and a width. The width can be predetermined by the datatype, as in DATE. If columns are of the NUMBER datatype, define precision and scale instead of width. See similar questions...

You can easily consolidate multiple ranges using Pivot Tables as long as the ranges you are dealing with have identical row and column labels. This procedure is accomplished using the Data - Consolidate command. However, using the PivotTable Wizard results in a table that is more flexible and customizable than the static table produced by Excel's Consolidation feature. See similar questions...

You only need to have the views ($Users), ($PeopleGroupsFlat), and ($PeopleGroupsHier) in your database. You also need the ($NamesFieldLookup) view if you want people to be able to begin typing the name in the To: field and have Notes find it automatically in the address books and fill in the rest. See similar questions...

can be used to create a document in a database. e.g., this will create a new document using the form "New Order" in the database orders.nsf in your Notes data directory: See similar questions...

See http://openacs.org/forums/message-view?message_id=160743 and http://openacs.org/forums/message-view?message_id=212780 See similar questions...

set new connection Dim myConnection As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=" & ob("Database").Value) myConnection.Open() Dim deleteCmd As New OleDbCommand("DELETE * FROM "& tableNameString, myConnection) deleteCmd.ExecuteNonQuery() myConnection.Close() See similar questions...

The table "object" includes all objects, regardless of which persistend class they are. For each object we save additional information to what other objects it refers. See similar questions...

The datamodel schema is saved in the table "globalvalues" as a serialized SOAP stream. Never touch this, because the datamodel-class needs it for a automatic structure comparision. In future versions more global values can stored in the table. See similar questions...

You can create a database file which gives you access to the calc-table. You cannot alter the table within base, instead you must use the calc-table Reduce the windows so that you can see the Database pane of the databasefile window beside the calc table. See similar questions...

If you want to place the links to other websites on your page please use the "External Link" feature. To create an external link: Select text or image and click the "Create Link" button on the upper right of the Page Editor toolbar. In the Insert Link dialogue, select Link Type “External” and click “Continue”. Type in the Link URL address in the space provided and select “Target” and click the “Insert” button. See similar questions...

We recommend you to create backups of your Recipe Center database and pictures (as you should for any of your personal files) regularly. The database is under the sub-folder \Data and the pictures under the sub-folder \Photo, but you may backup the entire "My Documents\My RecipeCenter\" folder. See similar questions...

You can add a table to any page that allows you to add text. To add a table, click on the icon located in the toolbar for "insert table". Enter the number of "rows" and "columns" you will be using (value must be 1 or more). Now you can fill out the "table attributes". Border= this refers to the border around the table or the outline of the table, so if you want to have the border thicker or more visible increase the value. See similar questions...

The ease with which you can create a table of contents will be directly related to how well you know the intricacies of your word processing program. Microsoft Word, Works, Word Perfect and Open Office all have the capacity to create tables of contents, but some writers still find it more expedient to create them manually. Second, your table of contents page should be located after the Copyright page, Dedication page and Preface page. See similar questions...

You cannot. Queries spanning more than one table are currently not supported in OpenOffice.org's own dBase implementation. There is an issue requesting this, so if you're interested in this feature, go and vote for it. See similar questions...