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.




Illustration 4: The Order Details Table (Partial View)

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.


Illustration 5: Select New to Create a New Query

The New Query dialog appears, as shown in Illustration 6.


Illustration 6: The New Query Dialog

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.


Illustration 7: The Populated Select Query Dialog (Composite View)








The Network for Technology Professionals

Search:

About Internet.com

Legal Notices, Licensing, Permissions, Privacy Policy.
Advertise | Newsletters | E-mail Offers