Creating a report/query calclulating a date on the current record from a previous records date

[Gearheadfmc]

Good day,

I am new to the forum. Lots of interesting information. I am also newer to Access, but not new to Databases -- years ago, I used a program called DBase III and wrote a ton of programs.

Today, I only have Access. I have been trying to solve this problem for a while, but with little success.

Here is the problem:

I must print a "predicted" scheduling report based on the time of a task and the due date from the task in the query preceding it.

As I stated, I have tried with no luck. So, I got the brilliant idea that I would create the formula in Excel (which I am pretty strong) and then import into Access! But that did not work. So, I tried to plug the formula into Access directly, and that did not work. Here is the Excel formula:

K3+Floor(I4/8,1)+Time(floor(I4/8*24,1),Mod(I4/8*24,1)*60,0)

Basically, I enter a date in K3, drag the formula down the column to create a new date, based on the hours required for the next task plus the previous date. The report is should look something like this:



Today: 10/19

Item Description Hrs Due Date
1 Test A 7.2 10/20/17
2 Test B 5.8 10/22/17
3 Test C 32 10/26/17

And, in Excel with the above formula (plus another to avoid weekend).

But, no matter what I try, when in Access, it comes out like this:

Today: 10/19

Item Description Hrs Due Date
1 Test A 7.2 10/20/17
2 Test B 5.8 10/20/17
3 Test C 32 10/23/17


Any ideas how to create a report from a query, dependent on the previous record, rather than the current date?

Any help would be appreciated.

TIA

Gearheadfmc

[Micron]

Your simplest solution might be to link the spreadsheet with it's calculations done as though it were a table and create the report from that. Or you could import it into Access, which would make it static.