Removing a Field from a Query


graphics/06inf22.jpg

graphics/one_icon.jpg

After you've displayed the query you want to modify in Design view, click above the field you want to delete.

graphics/two_icon.jpg

The column is selected. Press the Delete key on your keyboard.

graphics/three_icon.jpg

The field is removed. Click the Save button on the Standard toolbar in the main Access window to save the query design. When you run the revised query, this field will not be included.

INTRODUCTION

If you included fields in your query that are not pertinent to the query results, you can delete the fields. For example, if you used a wizard to build your query, you might have started with all the fields in the table and then realized that you only needed a select few. If so, you can remove any fields you don't need.

TIP

Hiding Fields

If you prefer, you can simply hide a field. For example, suppose that you need to use a field in your criteria, but you don't necessarily have to display that field in your results. To hide it, uncheck the check box under the field's name in the Show row.



Easy Microsoft Office Access 2003
Easy Microsoft Office Access 2003
ISBN: 789729598
EAN: N/A
Year: 2003
Pages: 174

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net