Can I append a query to a table without deleting the previous entries?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Veronica2010
    New Member
    • Mar 2010
    • 4

    Can I append a query to a table without deleting the previous entries?

    I want to save the entry and data of a query everytime it's ran. Is this possible?
  • topher23
    Recognized Expert New Member
    • Oct 2008
    • 234

    #2
    Check out the "INSERT INTO" SQL statement - the msdn article is pretty good http://msdn.microsoft.com/en-us/library/bb208861.aspx

    You can set up an append to add the results of your query to the table you're using.

    Comment

    • Veronica2010
      New Member
      • Mar 2010
      • 4

      #3
      Thanks topher23! Since I've taught myself Access I might have another question as I venture into this scenario. =D

      Comment

      Working...