Easier way to transfer field contents between tables

[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

 

[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.

 

[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