Dealing with Dates

[jeo]

I have a report where I need to manipulate some dates and I'm not really sure how to do it.
I'm attaching a document so this would be easier to understand.
Right now for each and every Project for the same person there is a new section with certain dates. Those dates are sorted in the right order, what I need, like in this example is to actually stick the 07/01/2004 in between the other 2 dates on the other Project.
This way all dates would be in Chronological order and a project doesn't really matter in this case. Dates are a lot more important.
Is this doable at all?
Thank you

 

[john471]

...for each and every Project for the same person there is a new section...

Consider putting the section per person, instead of project, then and add sorting by date.

 

[jeo]

I guess I'm not sure what that means, sorry...
I'm just starting out with Access, so if you could provide a more detailed explanation, that would be great.
Thank you.

 

[john471]

I don't really know what your table structure looks like; but I've done a little mock-up to try to help you out.

The zip file has a word doc, and a sample DB for you to look at.

HTH

Regards

John.

 

[jeo]

Thank you very much for all your time.
The table structure is perfect, you guessed it just right.
I appreciate your help.