Microsoft Access Programmers California

Microsoft Access Programmer Information

Call MS Access Solutions at (323) 285-0939 For Complimentary Consultation

Moving a Field to a Different Location on the Query Design Grid

Although the user can move a column while in a query's Datasheet view, sometimes you want to permanently alter the position of a field in the query output. You can do this as a convenience to the user or, more importantly, because you will use the query as a foundation for forms and reports. The order of the fields in the query becomes the default order of the fields on any forms and reports you build using any of the wizards. You can save yourself quite a bit of time by ordering your queries effectively.

To move a single column, follow these steps:

1. Select a column while in the query's Design view by clicking its column selector (the button immediately above the field name).

2. Click the selected column a second time and then drag it to a new location on the query design grid.

Follow these steps to move more than one column at a time:

1. Drag across the column selectors of the columns you want to move.

2. Click any of the selected columns a second time and then drag them to a new location on the query design grid.

Move the First Name and Last Name fields so that they appear before the Company field. Do this by clicking and dragging from the column selector for First Name to the column selector for Last Name. Both columns should be selected. Click again on the column selector for either column and then click and drag until the thick black line jumps to the left of the Company field.

NOTE

Moving a column in the Datasheet view doesn't modify the query's underlying design. If you move a column in Datasheet view, subsequent reordering in the Design view isn't reflected in the Datasheet view. In other words, Design view and Datasheet view are no longer synchronized, and you must reorder both by hand. This actually serves as an advantage in most cases. As you will learn later, if you want to sort by the Country/ Region field and then by the Company field, the Country/Region field must appear to the left of the Company field in the design of the query. If you want the Company field to appear to the left of the Country/Region field in the query's result, you must make that change in Datasheet view. The fact that Access maintains the order of the columns separately in both views allows you to easily accomplish both objectives.

This material orginally appeared in Alison Balter's book Mastering Microsoft Office Access 2007 Development. Reprinted here by author's permission.

When you need a Microsoft Access programmer for your Anaheim CA business, call MS Access Solutions at (323) 285-0939. We have over 25 years experience in Microsoft Access programmer solutions. We create Access database applications for all sectors, consisting of hospitals, government agencies, the U.S. military, universities, agriculture, workers services, and insurance provider. We can take care of the most advanced as well as complicated Access and also SQL Server database programming for your business as well as smaller projects, like fixing damaged Access database forms, MS Access reports, Access macros, and VBA code.

Access programmer cities we serve: Access Programmers Anaheim California

Access Programmers Long Beach California

Access Programmers San Diego California