I have a table Products, a tabel Sold. I have made a query where I use the total to group the sold product and make the sum of these quantity sold. Not all product are sold. I would like to bring this total value into a new tabel dimensions, where I find all the products. Now I would like to make a vba-code to copy the value from the product that was sold (from the query) into the table Dimensions. Key is the barcode. I can use Dlookup() to find the barcode but how can I write the value into the new table???
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations sizbut on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
copy field value to another table
- Thread starter fedum
- Start date
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question