Transferring all fields from a table to a query *

[socalblondie]

Hello,

How do I transfer all of the fields from a table into a query? When I use
the *, it just puts everything into one field. Is there an easy way to
spread them out so that each title has it's own field?

Thanks!

 

[KARL DEWEY]

When I use the *, it just puts everything into one field.
I never seen this problem. Post your query SQL.

Open the query in design view, click on menu VIEW - SQL View. Highlight
all, copy, and pate in a post.

 

[Ed Robichaud]

This is normal behavior! The "*" wildcard means "select all"; very handy if
you add/delete fields from the underlying table. If you really need/want to
see the field names in the query design column heads, then shift-click the
first-last fields in your table and drag the whole mess onto the query grid.
-Ed

 

[Albert D. Kallal]

This is normal behavior! The "*" wildcard means "select all"; very handy
if you add/delete fields from the underlying table. If you really
need/want to see the field names in the query design column heads, then
shift-click the first-last fields in your table and drag the whole mess
onto the query grid.
-Ed

Now, that is a very cool trick, and did not know you can do that!!!....

If you hold down control key, the you can click on fields, even when they
are not adjacent...when done....do as you suggest...drag and drop.

I always known you can drag one field at a time, and also you can double
click on a field and it is sent to the query grid...

But, I was NOT aware you could highlight as many as you wan (or all -- shift
control-page down), and then simply drag and drop the selection into the
grid...