F
fmt
Good Afternoon, am working on a Preventive Maintenance Programe, using the
access. mainly am using to tables.....1.agreement......2.schedule... the
first table inculded the agreement number,s/no....and the most importnt....1.
start date 2.Service Meter Hours 3.Est. hours Use, and in the seconed table
(Schedule) i have 1.Next Date 2.Est Service Meter Hours 3.Est Visit Type 4.
Schedule 5.SMU 6.Visit type.
what i want is based on the inputs of Start Date, Service Meter Hours, Est
Hours Use. from the first table, the programe shoud automaticly fill the
second table only for the first 3 records (Next Date, Est SMU, Est Visit Type)
based on the following :
the next date should be only after 250 Hours ..in other meaning generate a
date when the Est SMU is ( 250, 500, 750, 1000, 1250....etc)
the Est SMU it will be the accumlating of 250....and the visit type is (250
For 250,750,1250,1750,..) (500 for 500,1500,2500,3500,...) (1000 For 1000,
3000, 5000) (2000 for 2000, 4000, 6000)
Please note that the next date will note exceed the End Date of the contract.
for the second part of the second table (schedule , SMU, Visit type) this
will be done manully based on my Fead back of the SMU. in other words no need
to do the whole procces automaticly only the schedule and the visit type....
the SMU i have to enter on regular Baisis.
any help i'll Appreciate from all of you.
maybe i didnt explain that much i hope you can understand
access. mainly am using to tables.....1.agreement......2.schedule... the
first table inculded the agreement number,s/no....and the most importnt....1.
start date 2.Service Meter Hours 3.Est. hours Use, and in the seconed table
(Schedule) i have 1.Next Date 2.Est Service Meter Hours 3.Est Visit Type 4.
Schedule 5.SMU 6.Visit type.
what i want is based on the inputs of Start Date, Service Meter Hours, Est
Hours Use. from the first table, the programe shoud automaticly fill the
second table only for the first 3 records (Next Date, Est SMU, Est Visit Type)
based on the following :
the next date should be only after 250 Hours ..in other meaning generate a
date when the Est SMU is ( 250, 500, 750, 1000, 1250....etc)
the Est SMU it will be the accumlating of 250....and the visit type is (250
For 250,750,1250,1750,..) (500 for 500,1500,2500,3500,...) (1000 For 1000,
3000, 5000) (2000 for 2000, 4000, 6000)
Please note that the next date will note exceed the End Date of the contract.
for the second part of the second table (schedule , SMU, Visit type) this
will be done manully based on my Fead back of the SMU. in other words no need
to do the whole procces automaticly only the schedule and the visit type....
the SMU i have to enter on regular Baisis.
any help i'll Appreciate from all of you.
maybe i didnt explain that much i hope you can understand