Hiyas.
I've asked this question before, and i remember getting an outstanding answer from the guru's of this board.
Basically, i need the answer again however.
Problem:
i am setting up a database to track equipment (by asset number, description, etc.) and have fields that i can enter a date that each piece of equipment last had preventative maintenance performed on it. Maintenance can be performed at several different intervals, weekly, biweekly, monthly, quarterly, semi-annually, and annually.
What i would like, is a field that represents the last time a particular piece of machinery was maintained. A field for a user to select what particular interval of maintenance is required for that piece of equipment, and then another field which will list the date the maintenance is next due for that piece of equipment.
Currently, i have managed to get fields which let me enter the date maintenance was last performed, a combo box that lists the desired intervals and a box which lists the date maintenance will next be due. Unfortunately, it will only give the "Date Next Due" as 1 week beyond the current date.
So, there in lies the crux. Anyone able to give me a hand with this?
(i am using the dateadd function, but, i think my problem lies somewhere in the relation between the fields in the combo box and the periodicities)
formula i'm using is DateNextDue=DateAdd([Periodicity],1,[DateMaintenancePerformed])
now, one of the things that i can see being an issue is the "1"... since biweekly would be 2 weeks, Semi Annual would be 6 months.
help pwease!
I've asked this question before, and i remember getting an outstanding answer from the guru's of this board.
Basically, i need the answer again however.
Problem:
i am setting up a database to track equipment (by asset number, description, etc.) and have fields that i can enter a date that each piece of equipment last had preventative maintenance performed on it. Maintenance can be performed at several different intervals, weekly, biweekly, monthly, quarterly, semi-annually, and annually.
What i would like, is a field that represents the last time a particular piece of machinery was maintained. A field for a user to select what particular interval of maintenance is required for that piece of equipment, and then another field which will list the date the maintenance is next due for that piece of equipment.
Currently, i have managed to get fields which let me enter the date maintenance was last performed, a combo box that lists the desired intervals and a box which lists the date maintenance will next be due. Unfortunately, it will only give the "Date Next Due" as 1 week beyond the current date.
So, there in lies the crux. Anyone able to give me a hand with this?
(i am using the dateadd function, but, i think my problem lies somewhere in the relation between the fields in the combo box and the periodicities)
formula i'm using is DateNextDue=DateAdd([Periodicity],1,[DateMaintenancePerformed])
now, one of the things that i can see being an issue is the "1"... since biweekly would be 2 weeks, Semi Annual would be 6 months.
help pwease!