Sorry it took me so long on getting back to you. The powers that be have decided that the statistics derived from this process is not needed anymore.
Go figure, they asked for it for 2 years now and minds are now changed.
Thank You
Jim Wagner
On Wednesday, February 1, 2017 1:08 AM, "John Viescas JohnV@msn.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:
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
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
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: Jim Wagner <luvmymelody@yahoo.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (3) |
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