populating a query with all fields?

[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)

 

[Gary Miller]

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
________________________

 

[Cheryl Fischer]

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.

 

[JethroUK©]

both those methods populate one field at a time - i need to populate all
fields in one shot

thanx anyway

 

[JethroUK©]

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

 

[Cheryl Fischer]

Dragging the * down to the Field row or selecting MyTable.* is the same as
saying SELECT * from MyTable in SQL. It gets all fields.

 

[Cheryl Fischer]

i see it now

Good! Knew you would.

You're welcome.

 

[PC Datasheet]

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.

 

[Gary Miller]

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
________________________

 

[JethroUK©]

i'll go for that method - seems to be the cleanest thanx