Starting from scratch

[jakehale]

You folks have been great help in the past,,,,,, wondering if someone can help me with this one...

starting from scratch..... I need to count down and do some math

I need something that will count down days as the day pass'es, basically if i start with a number and as the days pass the number decreases (it isnt a basic 365 day calendar) on top of that i have a defined number of X's that need to be done per day. i can do an average for number of X's to complete per day ,,,,, but it needs to be adjustable..... like:

i start on a monday with 84 days and i have a 106 X's to complete in those 84 days, simple math says i need to do approximatily 1.3 days to compete X's in 84 days....

but come tuesday i will only have 83 days to compele the number of X's i have left.

I am thinking i need some sort of an initial input to start the calculations. then someway of editing it based on how many x's i get a day,,,,then i need the day to pass.

I have tried this in excel but it required basically redoing the formulas every day to adjust to for the differences.

this is a question to see if it could be "automated" in access and if it could,,,, can anyone help me with it,,,,,

thanks folks

Jake

 

[Navyguy]

Hello Jake

I am just thinking here…first this sounds like this may be better suited for MS project or something like that, however an other thought…

On a similar thread there was discussion regarding “tasks assigned to workers” and the discussion revolved around issuing tasks out by quantity, however it did not take into account how long the task took to complete. What I am suggesting here maybe you look at your 106 things to do in an hourly time frame verses a daily time frame.

You could possibility do 6 of your things in one “day” but 1 of your things may take 2 days to complete there by skewing your output. By using hour(s) to represent your things you can better allocate time resources. All of this is assuming that each of your things requires a different period of time to complete.

Does any of this make sense?

Here is the thread:
http://www.access-programmers.co.uk/forums/showthread.php?t=63043&highlight=tasks

 

[jakehale]

well

Hello Jake

I am just thinking here…first this sounds like this may be better suited for MS project or something like that, however an other thought…

On a similar thread there was discussion regarding “tasks assigned to workers” and the discussion revolved around issuing tasks out by quantity, however it did not take into account how long the task took to complete. What I am suggesting here maybe you look at your 106 things to do in an hourly time frame verses a daily time frame.

http://www.access-programmers.co.uk/forums/showthread.php?t=63043&highlight=tasks

Well in a (another) nutshell..... the 106 represents and number of items... this is what I have

I am an instructor at a flight school...

the X's i mentioned are really X's as we call them... it is an event that a student must complete.

the 106 represents the total number of X's that all my students need to complete this fiscal year.... we have been doing it manually but i thought it could be done "automated" like with access,, that way i could retain a data base of past students and i can compare from year to year....

i can figure the formula for doing the easy math stating how many X's i need a day to complete but i kinda wanted it to do it on a daily basis..... so on monday i need 106 X's to get all the students done in 84 training days, so i need to get 1.2 (there about) X's completed per day and i will be done

tuesday i would need 106 X's to get them done in 83 days and the average would change.......

wensday i completed 6 X's so now all i need is 100 in 82 days..... etc, etc, ect

and i could see all this by clicking the old access button and opening the database...

Not even sure if this can be done,,,, but i thought i would through line out here and see if someone could help....

thanks for the info...... and does my later explanation clear up it up a little bit more???

 

[WayneRyan]

Jake,

tblStudents:
StudentID
StudentName
StudentGraduationDate
StudentStuff

tblStudentTasks:
StudentID
TaskID
Completed

tblAllTasks:
TaskID
TaskDescription

Then when you open your main form:

ToDo = Dcount("[Completed]", "tblStudentTasks", "[Completed] = 0") / 
       DateDiff("d", Date, StudentGraduationDate)

just a quick stab at it,
Wayne

 

[jakehale]

Jake,

tblStudents:
StudentID
StudentName
StudentGraduationDate
StudentStuff

tblStudentTasks:
StudentID
TaskID
Completed

tblAllTasks:
TaskID
TaskDescription

Then when you open your main form:

ToDo = Dcount("[Completed]", "tblStudentTasks", "[Completed] = 0") / 
       DateDiff("d", Date, StudentGraduationDate)

just a quick stab at it,
Wayne

Wayne,,,, wish i could decifer this ,,,, i know how to use access, but i have not been into the VB or model portion of it. Where does this all go? thanks for helping,,,,,,