|
|
Queries - Adding All Fields by using the Asterisk Field lists in the Select Query window always contain an asterisk at the beginning of the list, which represents all fields. If you click and drag the asterisk to a field cell, the QBE window displays the table name followed by an asterisk in that cell. You can also select the table name followed by the asterisk from the field cell's drop-down list or type it in the field cell. When you run the query, all fields from that table will be included
in the resulting dynaset. Why would you use this method for creating queries rather than dragging the fields to the query design grid ? Using the asterisk is different from clicking and dragging all field names to the cells. If you use the asterisk, all fields will be included in the dynaset even if you change the structure of the table to add new fields. If you add the individual field names to the query, on the other hand, then you must manually add new fields to the query if you modify the structure of the table to include new fields.
The asterisk makes your work easier in this way, but it does make
it more difficult to sort or enter criteria for the fields.
|
||
|
|||