Updating the table with query

[Guest]

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

 

[Jeff Boyce]

Zaheer

If you know that the value of [Completion] is always [Start Date] plus
[Frequency], why bother storing it? You can create a query that calculates
that value without having to ever store it in the table.

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/