MS Access for the Business Environment: Create a Calculated Field with the Expression Builder - Page 2
June 5, 2003
6. Double-click the Order Details table to open it.
The Order Details table opens, as partially shown in Illustration 4.
We see 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.
7. Close the Order Details table.
We are returned to the Database Window.
8. Click the Queries icon in the left pane.
9. Click the New button that appears in the menu, as shown in Illustration 5 below.
The New Query dialog appears, as shown in Illustration 6.
10. Select Design View to create a query without using a wizard.
11. Click OK.
The Show Table dialog appears atop the Select Query dialog, where our actual query construction will take place.
12. Select Order Details from the tables list.
13. Click OK.
The Select Query dialog is populated with our selected table, as shown in Illustration 7.