Running Totals

[djo]

Hi Sorry if this has been answered before or is in the wrong section.

I am trying to get runnig totals for a project I am working on, The access database I am working on needs to do the following calculations with Carry Fowards

Day 1

Carry Forward = 0 Work In = 2 Total = 2 Work Processed = 1 Carry Forward = 1

Day 2

Carry Foward = 1 Work In = 2 Total = 3 Work Processed = 1 Carry Foward = 2

etc etc.

I have looked at many ways to do this but cannot find a solution that fits, I have also attempted to have the In / Out go to a template excel file and have calculations pre-set in there again to no avail. Any help would be greatly appreciated

 

[DannySeager]

So in this example I will call your work that you are carrying forward a "Job"

You could have a table with the following

TblJobActions
JobActionID (PK - Autonumber)
JobID (FK to Jobs Table)
JobDate
JobAction (Created/Completed)


Then create a query for All jobs that have been created before today and not completed. This will give you your carry forward.

SELECT * FROM TblJobActions WHERE JobDate < Date() AND JobAction="Created" AND JobID NOT IN(SELECT JobID FROM TblJobActions WHERE JobAction="Completed")

The it is simple to create queries for the number of jobs that have been completed today and the number that have been created today.

Then create a query to add them all together

 

[djo]

Cheers, I will have a go at this

 

[DannySeager]

You're welcome.

Just post back if you run into difficulties