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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Queries, see new fields when table design has changed 2
dynamic calculated field in query 3
Cannot see fields in query design view on laptop; Access 2003 1
Query Field Using Other Fields in the Query 3
Increment field by 1 on insert Query 2
Function of colon between table names when query in design view 4
Count text values in a Access Field 0
Query result shows all fields 1

Back
Top