Can't get " * " to work to add all fields to query - Help!

  • Thread starter Thread starter RonW
  • Start date Start date
R

RonW

I'm trying to add all fields to a query by clicking on the * at the top of
the list of fields. According to the info I have, it should do that with a
double click.
 
I assume that you are in design view and clicking on the Field row of the grid.

What does it do?
 
Karl: I'm in design view. In the field view at the bottom there is not a
asterisk as a selection, I'm actually working from the small dialog box at
the top. The very first selection is the asterisk, and alledgedly when you
double click there it should fill in all the fields in the bottom grid.
 
I'm trying to add all fields to a query by clicking on the * at the top of
the list of fields. According to the info I have, it should do that with a
double click.
Click to expand...

Well, it sort of works. It adds a pseudofield * to the first unused column in
the deisgn grid; when you open a datasheet you will see all of the table
fields at that position.

If you want each field in its own column, shift-select all the fields from the
field list and drag to the grid.
 
Selecting the asterisk (I do not know about the small dialog box at the top -
there are the tables shown in the space above the grid) it should fill in the
field row in only one column with table name, dot (.), and asterisk.
 
If you double-click on the table heading, it will select all the fields.

You can then click and drag all the fields at once into the grid.

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================
 
It does select ALL the fields BUT they are all included in that single
column - NOT a separate column for each field.

If you execute the query you will SEE all of the fields.

Select all the fields (except for that first entry) and drag/drop onto
the design grid on the bottom IF you want a separate column for each
field.
 
Back
Top