populating a query with all fields?

  • Thread starter Thread starter JethroUK©
  • Start date Start date
J

JethroUK©

Is there a formal menu method of populating a query with all the fields from
a table?

(not the dextrous mouse method - double-click and drag)
 
Jethro,

One method, if you want all of the fields, is to just drag
the asterisk into the first column. This is the wildcard for
all fields. Another method is to click on the first field,
scroll down to the last one and shift click to select
everything in between.

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________
 
The first row of the table that appears in the upper portion of the query's
design view contains a *. Drag the * to the first Field Row in the query.
Or, open the combo box in the Field Row. The first item listed should be
MyTable.* and you can select that item. Either method will populate your
query with all fields.
 
both those methods populate one field at a time - i need to populate all
fields in one shot

thanx anyway
 
i see it now - but the '*' method doesn't allow for criteria - i think i'll
have to go with the double-click, drag n drop method - thanx
 
Dragging the * down to the Field row or selecting MyTable.* is the same as
saying SELECT * from MyTable in SQL. It gets all fields.
 
Use the Query Wizard. After you select the table, the wizard will list all the
fields in the table. Click on the button with the double arrow to the right and
the wizard will add all the fields to the query.
 
If you need criteria with the '*' method then drag in the
criteria fields that you need separately and just uncheck
the 'Disply' option and you will be able to do the criteria
without displaying the fields twice.

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________
 
Back
Top