Eric - Netminder
asked on
Update previous record 1/3
This is part 1 of a 3-part question; the others are located at
https://www.experts-exchange.com/questions/28360145/Update-lots-of-previous-records-2-3.html
https://www.experts-exchange.com/questions/28360143/Script-to-poll-database-3-3.html (yes, I know they're out of order)
In the attached database, which is data retrieved from an ODBC-connected database to which I have read-only access, I can import the data shown in tblOrig. There are hundreds of IDNumbers; this is filtered data for one of them. Essentially, the table from which I am drawing this information lists every IDNumber, and revisions to it are shown in the Revision field, so the unique identifier of each record in the table is IDNumber & Revision.
What I would like to do is change the name of EditDate locally to StartDate, and add a column that says EndDate. I would like to automatically update the EndDate column when a new record is added to the table based on the StartDate; in other words, the preceding record of the filtered data would get an EndDate of the new record's StartDate minus one day.
Part 2 of this question has to do with updating thousands of records in one fell swoop. Part 3 of this question has to do with a way to import the data since the last time I imported it and adding it to this table.
My Access coding skills are... rusty... so any assistance would be greatly appreciated.
Thanks,
ep
efptest01.mdb
https://www.experts-exchange.com/questions/28360145/Update-lots-of-previous-records-2-3.html
https://www.experts-exchange.com/questions/28360143/Script-to-poll-database-3-3.html (yes, I know they're out of order)
In the attached database, which is data retrieved from an ODBC-connected database to which I have read-only access, I can import the data shown in tblOrig. There are hundreds of IDNumbers; this is filtered data for one of them. Essentially, the table from which I am drawing this information lists every IDNumber, and revisions to it are shown in the Revision field, so the unique identifier of each record in the table is IDNumber & Revision.
What I would like to do is change the name of EditDate locally to StartDate, and add a column that says EndDate. I would like to automatically update the EndDate column when a new record is added to the table based on the StartDate; in other words, the preceding record of the filtered data would get an EndDate of the new record's StartDate minus one day.
Part 2 of this question has to do with updating thousands of records in one fell swoop. Part 3 of this question has to do with a way to import the data since the last time I imported it and adding it to this table.
My Access coding skills are... rusty... so any assistance would be greatly appreciated.
Thanks,
ep
efptest01.mdb
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Alexey,
Thanks -- does exactly as advertised.
Gustav,
See my comment in part 2.
Regards,
Eric
Thanks -- does exactly as advertised.
Gustav,
See my comment in part 2.
Regards,
Eric
/gustav