documentation
.HELP!
Microsoft Query Documentation
Change the order of fields in a result set
Microsoft Query
previous page
next page
Show All
Change the order of fields in a result set
Click the
column heading
of the
field
you want to move.
Move the pointer over the column heading, and then drag the column to the place you want.
previous page
start
next page
Menu
Homepage
Table of contents
Getting Started
About using Microsoft Query to retrieve external data
Getting Help
Get program information about Microsoft Query
Keyboard Shortcuts
Use keyboard shortcuts in Microsoft Query
Move in the Microsoft Query panes by using shortcut keys
Select data and criteria by using shortcut keys
Edit data and criteria by using shortcut keys
Function keys in Microsoft Query
Use shortcut keys in the OLAP Cube Wizard
Installation and Data Sources
Install an ODBC driver so that you can access an external data source
Install OLAP providers
Setting Up Data Sources
Databases you can access
Specify a source to retrieve data from
Set up a data source that uses the Microsoft Access driver
Set up a data source that uses the Microsoft dBASE or FoxPro driver
Set up a data source that uses the Microsoft Excel driver
Set up a data source that uses the Microsoft ODBC for Oracle driver
Set up a data source that uses the Microsoft Paradox driver
Set up a data source that uses the Microsoft SQL Server driver
Set up a data source that uses the Microsoft SQL Server OLAP Services driver
Set up a data source that uses the Microsoft text driver
Creating, Opening, and Saving Queries
About creating a new query
Create a new query
Create a parameter query
Open a query
Save a query
Run, view, or edit an SQL command, procedure, or statement
Running Queries
Run a query automatically, or wait to run the query at a later time
Return a result set to Microsoft Excel
Execute an SQL statement or procedure
Creating and Connecting to OLAP Cubes
About OLAP queries
About creating an OLAP cube from relational data
Create an OLAP cube from relational data
Change content and settings of an OLAP cube
Delete an offline cube file
Changing Queries
Adding and Removing Tables and Fields
Add a table to a query
Delete a table from a query
Add or remove a field
Run, view, or edit an SQL command, procedure, or statement
Creating, Changing, and Removing Joins
Retrieve related records from multiple tables with joins
Retrieve records from multiple tables
Combine all the data from two tables
Retrieve records that two tables don't have in common
Create an outer join
Create an inner join
Create a self-join
Operators in joins
Remove a join
Limiting the Data You Retrieve
About using criteria
Limit the records you retrieve by using criteria
Specify what records to retrieve by using criteria
Retrieve records that match a specific value
Restore the full result set by removing criteria
Using Expressions
About expressions
Examples of expressions
Examples of expressions that use arithmetic operators
Examples of expressions that use comparison operators
Examples of expressions that use logical operators
Examples of expressions that use other types of operators
Creating Calculated Fields
Create a calculated field
Create a calculated field by using an expression
Create a calculated field by using a function
Functions you can use in a calculated field
Changing the Result Set
Change the layout of a result set
Format data in Microsoft Query
Finding, Sorting, and Reviewing Data
Go to a specific record in the result set
Sort records in a query
View different fields in a query
Changing Data in a Queried Database
About making changes to data in a queried database
Make changes to data in a queried database
Using Dynamic Data Exchange (DDE)
Use Dynamic Data Exchange (DDE) with Microsoft Query
DDE commands
Troubleshooting
Troubleshoot Microsoft Query
Troubleshoot OLAP queries and cubes
How Microsoft Query handles year 2000 dates
Get in touch
Submit feedback about this site to:
[email protected]
