- 1). Select the "Create" tab on the top ribbon menu. Click on the "Query Design" icon to open the "Query by Example" editor.
- 2). Select the tables you want to query from the "Show Table" dialog box by clicking once on the table name, and clicking the "Add" button for each table. When all of the tables have been added, click "Close" to dismiss the dialog box.
- 3). Double-click the field names you want to include in the query, adding them to the QBE frame. For example, consider a table that has the following columns: "FirstName," "LastName," "DOB," "Admitted" and "Discharged." "DOB," "Admitted" and "Discharged" are all date and time columns. The example query seeks the last names of all people born before 1970 in the database.
- 4). Add the date and logical criteria to the query by typing it in the "Criteria" field of the appropriate column. The example query adds this information to the "DOB," entering the criteria in the text box for that column formatted as "< #1/1/1970#."
- 5). Click the "View" icon to process the query and view the result set.
SHARE
