All Table fields in Query Design View

[Filo]

This may be a very easy question:
What is the easiest way to display in a query all fieds of a table?
Currently I have been adding one item at a time but it is taking too long.

Thank you.

 

[Rick Brandt]

This may be a very easy question:
What is the easiest way to display in a query all fieds of a table?
Currently I have been adding one item at a time but it is taking too
long.

Thank you.

You can drag down the first item listed in the table (the astrerisk) and
that will return all fields by itself.

You can also click on the first field, then hold shift while clicking on the
last field. That will highlight all fields which cab then be dragged down in
one move.

 

[Irene]

in the query, it will ask you to choose the table. then u choose the table
which you want, then after that you just double click the first row of the
table which is "*". you just double click the *, and it will show all the
field of the table in the query. hope it can help you. all the best!

 

[Filo]

Thank you both, this is very helpful.

You can drag down the first item listed in the table (the astrerisk) and
that will return all fields by itself.

You can also click on the first field, then hold shift while clicking on the
last field. That will highlight all fields which cab then be dragged down in
one move.