append query

[Guest]

I have an append query that im using to send records to a table. Everytime i add new records and append them it keeps putting in the other records that i already added. Is there a way to clear the append query before i add the new records and if so how do i do it. Im just learning and there is so much to learn. Thank you

 

[Dan Artuso]

Hi Jenny,
You'll have to post a bit more info for someone to help out.
Every saved query that you have is really just a SQL statement.
With your query in design view, go to the View menu and select: SQL View
This will now show you the SQL statement that is really your query.

Post that statement here and we'll go from there.


--
HTH
Dan Artuso, Access MVP

I have an append query that im using to send records to a table. Everytime i add new records and append them it keeps putting in

the other records that i already added. Is there a way to clear the append query before i add the new records and if so how do i do
it. Im just learning and there is so much to learn. Thank you

 

[Steve Schapel]

Jenny,

Can you please post back with more details of the data, what your append
query looks like (go to View|SQL menu and copy/paste the query SQL into
your post would be ideal), and maybe some examples of what you want, and
how what you are getting is different from what you want.