Transferring all fields from a table to a query *

  • Thread starter Thread starter socalblondie
  • Start date Start date
S

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!
 
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.
 
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
 
Ed Robichaud said:
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
Click to expand...

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...
 
Back
Top