Hi everyone,

I went through some of the questions and have not been successful at finding
the simplest and concise way of tracking contracts for my reporting purposes.
Currently, I track multiple tasks for one contract number. As a result, I end
up have multiple task dates for one project that I will need to summarize
into a monthly report. At this point, I have been doing it manually and has
been quite time consuming. I am hoping there is a faster way for me to get
the same results.

Here is an example of what I'm after. I have a report that looks like the
example below:

Contract Task Start Date Task End Date
101010 01/05/99 12/3/05
101010 12/8/04 11/5/07
356 08/06/05 4/8/07
12345 11/3/89 11/01/01
12345 10/6/01 12/4/07


Now with that said, what are the steps I should take and the formula I
should use to get a result similar to this kind:

Contract Task Start Date Task End Date
101010 01/05/99 11/5/07
356 08/06/05 4/8/07
12345 11/3/89 12/4/07

Any help is GREATLY appreciated!