Is there a quick way to create an Update query?

T

Tony Williams

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!
 
J

John Spencer

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
 
P

Peter Kinsman

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
 
T

Tony Williams

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Append Crosstab Query to Existing Table 0
How to Create an S-Curve from Custom Field? 0
Sorting Multiple Tables 1
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Setting column width in a table with a macro is not working 0
Creating a Chart on form from selected data in query. 0
Create a chart from a table in word thats dynamic 0
How to have two tables on same line? 1

Top