Select fields to add to the design grid in a query or advanced filter

To select	Do this
A field	Click the field name.
A block of fields	Click the first field in the block, hold down SHIFT, and click the last field.
Noncontiguous fields	Hold down CTRL as you click the fields.
All fields	Double-click the title bar of the field list or click the asterisk (*). (For more information on using the asterisk, click .)

Notes

• Once you've selected fields in the field list, you must drag them to the design grid.
  
  
• When you drag more than one field at a time, Microsoft Access places each field in a separate column. If you drag the asterisk to the grid, Microsoft Access places the table or query name in one column and attaches a period and asterisk to the name (for example, Categories.*). After either operation, the datasheet looks the same.
  
  
• Instead of dragging, you can also add fields by double-clicking the name in the field list or selecting a field directly from the list box in the Field row on the grid.