Insert Fields in Query Design Mode

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

While creating query in Design mode, there is painful procedure of inserting
fields names by clicking on the Show Table pane, selecting the table & then
choosing the field , so on & so forth.

The procedure is really killing, when we have 15 to 20 fields to update or
to choose. It is a virtual hell when calculations are involved.

Is there a shorter /quicker way to insert a field (other than VBA or SQL way )

Any help considered a great relief
 
You can use the SQL view and type in the field and table names.
You can add the table to the query and then double click on fields to add
them to the query grid.

If you are using a query wizard, then just add one field from each table you
need and then modify the query after it is created.
 
Back
Top