Is there a quick way to create an Update query?

I have a table with about 30 fields. I need to update it with data from
another table. I understand how to create an update query but is there a
quicker way of adding the field names of the table holding the data rather
than have to type in the name like tablename.fieldname for every field that I
want to update? I don't seem to be able to drag and drop the field name of
the second table as I can for the destination table.
Hope I've explained that!

I don't know of any quick method to do this.

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

Tony Williams wrote:
I have a table with about 30 fields. I need to update it with data from
another table. I understand how to create an update query but is there a
quicker way of adding the field names of the table holding the data rather
than have to type in the name like tablename.fieldname for every field that I
want to update? I don't seem to be able to drag and drop the field name of
the second table as I can for the destination table.
Hope I've explained that!

Once you have typed tablename. for the first time, you can use Ctrl+C to
copy it and then Ctrl+V to paste it into the subsequent Update To cells so
you only have to type the field names.

Peter

"John Spencer" wrote in message
...
I don't know of any quick method to do this.

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

Tony Williams wrote:
I have a table with about 30 fields. I need to update it with data from
another table. I understand how to create an update query but is there a
quicker way of adding the field names of the table holding the data
rather than have to type in the name like tablename.fieldname for every
field that I want to update? I don't seem to be able to drag and drop the
field name of the second table as I can for the destination table.
Hope I've explained that!

Thanks John I thought that was the case, a long copy and paste process I think.
Tony

"John Spencer" wrote:

I don't know of any quick method to do this.

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

Tony Williams wrote:
I have a table with about 30 fields. I need to update it with data from
another table. I understand how to create an update query but is there a
quicker way of adding the field names of the table holding the data rather
than have to type in the name like tablename.fieldname for every field that I
want to update? I don't seem to be able to drag and drop the field name of
the second table as I can for the destination table.
Hope I've explained that!
.