tripopla.blogg.se - Lotus 123 millennium

For more information, see Overview: Data Query Add-In (DQA). If your database needs are simple, your computer doesn't have a large amount of memory or disk space, or you need to work with query tables created in 1-2-3 Release 5, you may find that DQA is a useful alternative to the Create - Database - Query Table command. With DQA, you can create query tables and crosstabs, and connect to external database tables. If you want to get Help about 1-2-3, click in the sheet outside the query table, then choose Help - Help Topics or press F1.ġ-2-3 also offers the Data Query Add-In (DQA), which gives you data query functionality similar to that in 1-2-3 Release 5.Approach Help contains more information about working with query tables, which are called worksheets in Approach. If you choose Help - Help Topics, click a Help button, or press F1 while you are creating a query table or when the query table is active, Approach Help topics appear.Use the data in calculations, charts, and maps.įor more information, see Working with a query table.When the query table is in Output mode, you can perform the following tasks:

Working with a query table in Output mode

Change the fields that appear in the query table.

Edit, add, or delete records in the source database table.

When the query table is in Edit mode, you can perform the following tasks: In this release of 1-2-3, when the query table is in Output mode, you see the data in the output range. When you click in the sheet outside the query table, the query table switches to Output mode, or becomes inactive. Initially, the query table is active, or in Edit mode. Similarly, if records in the source database table change, you can refresh the query table to reflect the current data. Any changes you make to the data in the query table in Edit mode are automatically made to the source database table. Query tables and database tables are linkedĪ query table is linked to the database table you queried. To avoid losing data, create a new sheet to hold the query table. It appears as an Approach object embedded in the 1-2-3 sheet.Ĭaution In this release of 1-2-3, the query table writes over existing data in the cells in which you place it. The query table is an Approach view of the contents of the database table you queried. When you create a query table, 1-2-3 loads a portion of Lotus Approach into memory.

Bring data from an external database table into 1-2-3.

The query table contains a copy of all the database records from the table you specified. You create a query table in 1-2-3 to find, sort, and edit the information stored in a 1-2-3 database table or an external database table.