Step 1: Open the New Query Dialog Box

From the Database window, select Queries in the Objects bar and click New to open the New Query dialog box. 

 

 

 

Step 2: Start the Simple Query Wizard

Choose Simple Query Wizard and click OK to open the first Simple Query Wizard dialog box. 

 

 

 

Step 3: Choose a Table

Open the Tables/Queries drop-down list and select the first table from which to choose a field. 

 

 

 

Step 4: Select Fields

Select a field you can include in the query table results and click the > button to add it to your query. Select as many fields from as many different tables as you want and click Next when you're ready to continue. 

 

 

 

 

Step 5: Give the Query a Name

The next dialog box asks you whether you want a detail query (which shows every record) or summary query (which is used for totalling values). Detail is the default, so click Next to continue. Then enter a name for the query and click Finish to create your query, which appears in table form. 

 

 

Step 6: Query Results

Access displays the records showing only the fields you specified in Datasheet view. To close the query, click the window's Close button.