[MS_AccessPros] Query: Make EndDateTime of a record the StartDateTime of next record

 

Hi,

I have a query that lists products in the sequence they are to be manufactured.  I calculate the time it will take to make each product (multiply individual per piece time times the quantity, result is in minutes).  I have 2 calculated columns at the end, one is StartDateTime (set to now()) and EndDateTime (calculated using dateadd function, adding the manufacturing minutes to the StartDateTime column.   This tells me if I started all products at now(), I would complete each product at some calculated time.

Problem is, I make the products in sequence, not at the same time.

How can I make the EndDateTime of record number one, become the StartDateTime for record number two, EndDateTime of record number two the StartDateTime for record number three and so on all the way to the last record.

Any suggestions?  I'll really appreciate this!

__._,_.___

---

Posted by: lrheimpel@gmail.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.

---

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___