Link to home
Start Free TrialLog in
Avatar of Eric - Netminder
Eric - NetminderFlag for United States of America

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
ASKER CERTIFIED SOLUTION
Avatar of als315
als315
Flag of Russian Federation image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
See my suggestion in 2/3.

/gustav
Avatar of Eric - Netminder

ASKER

Alexey,

Thanks -- does exactly as advertised.

Gustav,

See my comment in part 2.

Regards,

Eric