Same records stay in Append qry. WHY?

T

troy

I run an append query and after they move I pull up the datasheet view from
query and the same records are still showing. Why? I looked at my target
table and they did move corrrectly so why are they still in my query? Please
help!
 
R

Rick B

Huh? An append query will add data to a table. It does not take it away
from the source. It performs a "copy" and "paste", not a "cut" and "paste".
 
T

troy

That is correct but when it adds and "it does it correctly" adds records to
the target table. It also keeps the same records in the query everytime you
bring up the query to run it. If I run the query and 10 records append then
the next day I run it and 20 new records append. I will show 30 records in my
record set. They keep adding up and appending over and over while my table
get hugh! In other words I cont get them out of my query. I run the query
then to check it I click on the datasheet view and they are still in there.
What gives?
 
J

John Vinson

That is correct but when it adds and "it does it correctly" adds records to
the target table. It also keeps the same records in the query everytime you
bring up the query to run it. If I run the query and 10 records append then
the next day I run it and 20 new records append. I will show 30 records in my
record set. They keep adding up and appending over and over while my table
get hugh! In other words I cont get them out of my query. I run the query
then to check it I click on the datasheet view and they are still in there.
What gives?
Click to expand...

Reread what Rick said.

You're assuming that an Append query "moves" records from one table to
another.

That is NOT what an Append query does.

It leaves the records in the source table unaffected, and adds copies
of those records to the target table.

If you run the query again tomorrow, it will select those same records
again, since they are still there in the table, unless you have some
criteria which filter the records.


John W. Vinson[MVP]
 
T

troy

Yes I have creteria that states <>table.field under each field. So what I
want it to do is if there has been any changes to that field. To append it to
my target table. I know it does not delete the source table but it should not
(the data) remain in the query results either. Once I run the query it should
append the dat to the target table then I should no longer be able to view
those same results in the query datasheet view. It should be blank correct?
 
J

John Vinson

Yes I have creteria that states <>table.field under each field. So what I
want it to do is if there has been any changes to that field. To append it to
my target table. I know it does not delete the source table but it should not
(the data) remain in the query results either. Once I run the query it should
append the dat to the target table then I should no longer be able to view
those same results in the query datasheet view.
Click to expand...

If the Query retrieves records before the append query runs...
then it will retrieve the same records after the append query runs.
It should be blank correct?
Click to expand...

No. That is SIMPLY NOT CORRECT.

You are assuming that an append query does something to the data in
the source table. It doesn't. It leaves the source table *exactly* as
it was prior to running the query.


John W. Vinson[MVP]
 
Top