>I have a view from a table with a blank column for meter readings. I am using a grid to put the meter readings into the blank fields. I want to append the data from the view to a different table.
If you're planning to append the data as new records in a table, then either INSERT or APPEND will do. Use the
RecordSource of the grid, and SCAN it (or use a do while loop if it's faster) adding the data one record at a time if any field needs to be changed. If it's just a matter of adding all data in cursor/view/table A to table B, use APPEND FROM.
HTH
Barbara