Copying table rows

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

This may not be the correct forum to post this on but I don't quite know
where to post it. I have a small table with about 30 rows in it and I want
to write rows in another table that contain two columns of data from the
first table. The first table contains 7 columns. Two of them are 'Cat' and
'Amount'. The second table only has these two columns.

I have a form set-up with table 2 as the control source so as I write the
contents of the two fields it will update the 2nd table but I can't figure
out how to sequentially read the rows in the first table to get these values.

Can someone help me get over this hurdle?
 
This may not be the correct forum to post this on but I don't quite know
where to post it. I have a small table with about 30 rows in it and I want
to write rows in another table that contain two columns of data from the
first table. The first table contains 7 columns. Two of them are 'Cat' and
'Amount'. The second table only has these two columns.

I have a form set-up with table 2 as the control source so as I write the
contents of the two fields it will update the 2nd table but I can't figure
out how to sequentially read the rows in the first table to get these values.

Can someone help me get over this hurdle?
Click to expand...

Do you want the second table to contain data from all 30 rows of the
first table? I'm not sure WHY you would want to store the same data
redundantly in two tables (it's generally a bad idea), but the
simplest way to do so is to simply run an Append query. Select Cat and
Amount, change the query to an Append query, name Table2 as the
destination, and run the query. No Form is needed.

John W. Vinson[MVP]
 
Back
Top