Selasa, 31 Januari 2017

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

 

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: luvmymelody@yahoo.com
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (1)

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.


.

__,_._,___

Tidak ada komentar:

Posting Komentar