the Order Details table to open it.
Details table opens, as partially shown in Illustration 4.
Illustration 4: The Order Details Table (Partial View)
that the information we want to drive and present in our example, Net Price,
for each of the line items, is composed of data currently existing in two
separate fields, Unit Price and Discount, as we have indicated.
Now that we have a precise understanding of the source fields involved, let's
close the Order Details table.
Close the Order
returned to the Database Window.
Click the Queries
icon in the left pane.
Click the New
button that appears in the menu, as shown in Illustration 5 below.
Illustration 5: Select New to Create a New Query
The New Query dialog appears, as shown in Illustration
Illustration 6: The New Query Dialog
Select Design View to create a query without using a wizard.
The Show Table dialog appears atop the Select
Query dialog, where our actual query construction will take place.
Select Order Details from the tables list.
The Select Query dialog is populated with our
selected table, as shown in Illustration 7.
Illustration 7: The Populated Select Query Dialog