Is there a quick way to create an Update query?

  • Thread starter Thread starter Tony Williams
  • Start date Start date
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!
 
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
 
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
 
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

Update Query Help *urgent* 0
update query 2
Update Query 6
Quick way to update records 2
Create Update Query 4
update query vs make query 5
Update Record Performance - Query vs Code 1
Update Query 4

Back
Top