Easier way to transfer field contents between tables

J

John B. Smotherman

Hello,

I've created a database to keep track of all our equipment, located in
multiple rooms, all over the building. We now have an annual requirement to
physically inventory each item of equipment. I've writen a VBA routine to
create from the main table a subtable of all the items in a particular
location, based on user input of location.

Is there an easier way to transfer the contents of one of the fields in the
subtable back to the main table than to iteratively process each subtable
record? I'm wondering if there's a query or SQL method that will do it?

Thanks.

JBS
 
D

Douglas J. Steele

SQL would likely be the best approach. Note, however, that there's no "MOVE"
in SQL: you have to copy the data from table 1 to table 2, and then delete
the same data from table 1. That would suggest that using a transaction
might be appropriate.

That having been said, though, are you sure you need to transfer data from
the subtable to the main table? That sounds unusual to me.
 
J

John B. Smotherman

Oops, I didn't mean "move", I meant "copy". The particular field I'm wanting
to copy is a Y/N that indicates a particular line item has been physically
inventoried. I want to copy that from the subtable, which contains only a
subset of the data, back to the main table.

Thanks.
JBS
 

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

Top