Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 457
  • Last Modified:

Update previous record 1/3

This is part 1 of a 3-part question; the others are located at
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_28360145.html
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_28360143.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
0
Eric AKA Netminder
Asked:
Eric AKA Netminder
1 Solution
 
als315Commented:
You can do it with query (in attached sample Query1 is used for calculation of next record and Query2 - for update tblNew)
833371-efptest01.mdb
0
 
Gustav BrockCIOCommented:
See my suggestion in 2/3.

/gustav
0
 
Eric AKA NetminderAuthor Commented:
Alexey,

Thanks -- does exactly as advertised.

Gustav,

See my comment in part 2.

Regards,

Eric
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now