When you say that you want one of the field sets to "replicate to the other",
do you mean that you simply want to copy the data in that field? If so, that
can easily be accomplished using an Update query (in query design view, go to
the Query Type button on the toolbar and change the query type to Update).
As for your WorkDTC, this can probably be calculated like this:
(Date() - [OrigDTC]) AS WorkDTC
This will subtract the Original Days to complete from the current date,
which should give you your current days to completion.
-Chris
"tjdaly" wrote:
> I have a project database that among other things tracks the dates of our
> projects. We start with an Original Project plan which is a series of 15 to
> be exact fields that have Days to Complete for each task in teh project. All
> of these fields are driven off of the Project Kick Off Date. In the database
> currently I have an Original Kick-Off Date and a then two sets of dates for
> the same project, one being the Original set, which I want to freeze at the
> Original Project plan phase in order to track slippage to the original and
> then I have a concurrent Working set of dates, which continue the
> calculations done earlier yet they can be altered as the project ebbs and
> flows. Thus I have two field sets that are being added to the Kick-Off date,
> at the outset they are the same and then shortly thereafter they diverge.
>
> Is there anyway to enter those days into one of the field sets and have them
> replicate to the other? The sets are OrigDTC and WorkDTC with DTC being
> Days To Complete. Not sure if this matters but all of the data is being
> entered into a form.
>
> Any help would be appreciated.
> --
> TJ Daly
|
Similar Threads
