Express Query dialog box

Use the Express Query dialog box to create a query of Express data.

Dialog box components

Choose Database box -- Lists Express databases that are currently attached. Use the Attach Database and Remove Database buttons to add a database to the list or remove a database from the list. You can attach multiple databases.

Attach Database button -- Accesses the Attach Database dialog box where you can select a database to attach.

Remove Database button -- Detaches the database that is selected in the Choose Database box. You cannot detach a database that is being used by an open query. If a query is in process, or if results are displayed on an open report, you must cancel the query or delete the results before detaching the database.

Available Measures box -- Lists all measures in the database.

Selected Measures box -- Lists current measure selections.

Report columns box -- Provides information about the dimensions that correspond to the selected measures.

Add One button Add One button -- Adds a measure that is selected in the Available Measures box to the Selected Measures box.

Add All button Add All button -- Adds all measures in the Available Measures box to the Selected Measures box.

Remove One button Remove One button -- Deletes a selected measure from the Selected Measures box.

Remove All button Remove All button -- Deletes all measures from the Selected Measures box.

Custom Measures button -- Accesses the Custom Measures dialog box. 

Selector button -- Accesses the Selector dialog box.