To Rename a field in a query :
Place the insertion point to the left of the first letter of the field name in the design grid.
Type the new name followed by a colon | |
| |
About using the asterisk in the query design grid
Selecting the asterisk (*) in a query has an advantage over selecting all the fields. When you use the asterisk, the query results automatically include any fields that are added to the underlying table or query after the query is created; and automatically exclude fields that are deleted.
When you use the asterisk, you can't sort records or specify criteria for fields unless you add those fields along with the asterisk to the design grid.
If you type an asterisk in the Field row rather than dragging it, you must type the table name also |
| | |
Combining Text fields
If you want combine two fields containing text values use the & operator. | |
| |
Partial Text fields
If you want a part of the field you can use the operator Left, Mid or Right. | |
| |
Specify criteria or a sort order when using the asterisk in the design grid
Double-Click the asterisk (*) from the field list to the Field row in the design grid.
Add the fields you want to sort or set criteria for by Double-Click them from the field list to the Field row.
Select a sort order in the Sort cell for the fields you want to sort.
Enter criteria in the Criteria row for the appropriate fields.
Clear the Show check box for all fields except the asterisk; otherwise those fields will appear twice in the query's results. |
| | |
Calculated Field:
For custom calculations, you need to create a new calculated field directly in the design grid. You create a calculated field by entering an expression into an empty Field cell in the query design grid. | |
| |
| You cannot use subquery to define a field |
