append query

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

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
 
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


Jenny Calhoun said:
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
Click to expand...
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
 
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.
 
Back
Top