Re: [MS_AccessPros] Append records to a specific column in a table

 

Jim-

Not enough info.  Please post your SQL and, if the SQL is being generated in VBA, your code.  And what are the table structures?

John Viescas, author

Effective SQL

SQL Queries for Mere Mortals

Microsoft Office Access 2010 Inside Out

Microsoft Office Access 2007 Inside Out

Building Access Applications

http://www.viescas.com/

On Feb 1, 2017, at 00:39, luvmymelody@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

Hello all,

I am trying to append records from a table into another table. the issue is that I am trying to append one column from a table into a specific column. then append another field from another table the next day to the next column in the new table.

we are trying to track numbers from a download each day. The table is refreshed each day and we are trying to capture the number each day. with the table being deleted each day we have no way of keeping track of the numbers in the column as history.

we tried to run an append query and the first day it did it correctly but the next ensuing days appended the next column starting at different rows. How do I get the records to append starting at the first row each day?

Thank You

Jim Wagner

__._,_.___

---

Posted by: John Viescas <johnv@msn.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (2)

---

Have you tried the highest rated email app?

With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

---

Visit Your Group

• New Members 2

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___