append records

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

Guest

I want to append records one at a time to another table how do i do this. Everytime i try if just keeps puttling all of them there
 
How are you trying to do this? If you're using an append query similar to
this:

INSERT INTO NewTable (Field1, Field2)
SELECT Value1, Value2 FROM OldTable;

then yes all records will be appended. To control how many are appended, you
must change the query so that it will return only one record; say, by using
a WHERE statement:

INSERT INTO NewTable (Field1, Field2)
SELECT Value1, Value2 FROM OldTable
WHERE Value1 = "MyValue";

Not knowing how you would define "one record" in terms of identity, and not
knowing any more details, I hope that this generic suggestion is helpful.


--
Ken Snell
<MS ACCESS MVP>

Jenny Calhoun said:
I want to append records one at a time to another table how do i do this.
Click to expand...
Everytime i try if just keeps puttling all of them there
 
Back
Top