Scheduling by using dates

[Guest]

I have built a database to track maintenance contracts. Basically what I want
to do is have some sort of automated function where it will automatically
calculate the next service date. By using a last scheduled maintenance field
date. I will have to enter the last date it was serviced and then I want it
to tell me when to service it again. I have certain intervals such as
monthly, semiannually, quarterly, and yearly. I don't know where to start. I
am using access and not SQL. What I want to do is have it automatically
schedule the next service appointment after service has been completed. To do
this it would have to replace the date in the last scheduled maintenance
field; how do you do that? Can anybody please help me?

Thanks so much! I know it sounds confusing.

 

[Guest]

Don't store the next scheduled date, only the last scheduled date and the
length of time before next service (example 1 year). Use the DateAdd
Function to get, in your queries, forms, and reports the date that they are
next due. You can use that function to get the actual date that they are due
and then use that generated date with the DateDiff function to get the number
of days, weeks, etc. before the next service date is due.

--
Bob Larson
Access World Forums Super Moderator
Utter Access VIP
____________________________________
Access 2000, 2003, 2007, SQL Server 2000, Crystal Reports 10/XI, VB6
WinXP, Vista

 

[pietlinden]

Don't store the next scheduled date, only the last scheduled date and the
length of time before next service (example 1 year). Use the DateAdd
Function to get, in your queries, forms, and reports the date that they are
next due. You can use that function to get the actual date that they are due
and then use that generated date with the DateDiff function to get the number
of days, weeks, etc. before the next service date is due.

--
Bob Larson
Access World Forums Super Moderator
Utter Access VIP
____________________________________
Access 2000, 2003, 2007, SQL Server 2000, Crystal Reports 10/XI, VB6
WinXP, Vista

I agree, except in the case where you need to record when/if the
service was performed (and by whom). If that's the case, then you'd
have to create records. But if you only want to know the next service
date, just use a query.