Adding a single field
You add a single field in several ways. One method is to double-click the field name in the Field List (also called a Table window); the field name immediately appears in the first available column in the QEB pane.
Alternatively, drag a field from a table in the top portion of the query designer, and drop it on a column in the QBE grid. Dropping a field between two other fields in the QBE grid pushes other fields to the right.
Another way to add fields to the QBE grid is to click an empty Field cell in the QBE grid, and select the field name from the drop-down list in the cell, or type the field’s name into the cell. Figure 36-7 shows selecting the Cost field from the drop-down list. Once selected, simply move to the next field cell and select the next field you want to see in the query.
You’ll find a similar list of all the tables in the query in a drop-down list in the Table row of the QBE grid. After selecting the fields, run the query by clicking the Datasheet button or the Run button on the Design tab of the Ribbon. Click the Design View button on the Design tab to return to the design window.
FIGURE 36-7
Adding fields in the QBE grid. Clicking the down arrow reveals a drop-down list from which you select a field.
// Related Posted - GOOGLE!
Related Websites
- 50 really useful Android tips and tricks [/caption] Android is a great little mobile operating system for the modern smartphone, but it can feel a little bewildering...
- You Need a Budget (YNAB) Review For the past 3-months or so I've been searching for the right software to use to manage our budget. I've...
- So how do you like your rejection letters? [/caption] Rejection letters. Or rejection e-mails. Well, no one likes to be rejected but us writers need to face that...
- A List of Useful Microsoft Office Cheats & Shortcuts Learning how to use Microsoft Office is fun, especially if you become familiar with the shortcuts of its programs. Here...
- OnPar Golf Touchscreen GPS User Reviews Send this to a friend OnPar Golf Touchscreen GPS Manufacturer: OnPar Customer Rating: List Price: $479.95 Sale Price:...
