hi all!  i made a table 'Routine Scheduling for maintenance', in which i have
following field
1) Routine card no (text)
2) Equipment name (text)
3) Frequency (text -----[days])
4) Start Date (date/time)
5) Completion (date/time)

in this table i insert many records but i left the 'completion date' field
empty. i want to make a query in which 'completion date' update itself just
by checking the frequency and add that frequency into the 'start date' for
each records in the table at one time. e.g . i have different equipments like
valves, motor etc and they have different freqency for maintenance like 1
monthy, 3 monthly and 6 monthly. As soon i run the query it should update the
'Completion date' field just by adding the 'Frequency' into the 'start date'
field. i know this is a little bit confusing and difficult but i am sure you
guys can help me , thanks
-
Zaheer
Acesss Database Designer
Planning Supervisor