ArffMarine
Technical User
I have read two seperate FAQ's on this subject (faq702-4851 and faq181-261). Neither one seems to fit what I want to do and if they do, I don't know how to apply them.
We have a 64-day course that is broken into six blocks of instruction. What I want to do is enter the start date of Block I and have the form automatically fill in the start and end dates for each subsequent block. On my form "ClassInformation" I have 10 fields:
blockIStart
BlockIIGrad
BlockIIIStart
BlockIIIGrad
BlockIVStart
BlockIVGrad
BlockVStart
BlockVGrad
BlockVIStart
BlockVIGrad
Blocks I & II are taught by the same instructor so calculating the 14 days as one block makes for shorter code.
The Blocks Vary in length
Blocks I & II toatal 14 days
Block II is 18
Block IV is 16
Block V is 7
Block VI is 14
I also would like to factor in holidays. for this I have a table "Holidays" with two fields:
holidate (Stores the date)
holiname (Stores the name)
I hope I have posted sufficient information. Thank you
ARFF Marine
We have a 64-day course that is broken into six blocks of instruction. What I want to do is enter the start date of Block I and have the form automatically fill in the start and end dates for each subsequent block. On my form "ClassInformation" I have 10 fields:
blockIStart
BlockIIGrad
BlockIIIStart
BlockIIIGrad
BlockIVStart
BlockIVGrad
BlockVStart
BlockVGrad
BlockVIStart
BlockVIGrad
Blocks I & II are taught by the same instructor so calculating the 14 days as one block makes for shorter code.
The Blocks Vary in length
Blocks I & II toatal 14 days
Block II is 18
Block IV is 16
Block V is 7
Block VI is 14
I also would like to factor in holidays. for this I have a table "Holidays" with two fields:
holidate (Stores the date)
holiname (Stores the name)
I hope I have posted sufficient information. Thank you
ARFF Marine