A little confused

[Golfinray]

Dates have been the hardest thing for me to pick up in Access. I don't know
why I struggle with them so much but they confuse me. I have start dates,
progress dates, and end dates. Projects start, have several steps, and then
end. So a project may start 1/1/2008, step 1 is finished 1/8/2008, step 2 is
finished 1/20/2008, etc right on up to completion date of 4/15/2008. So I
have Project name, project number, some other project info, and dates. First,
do I need to have a list, like an autonumber only of dates, and then each
step in the process in one table? Many tables? Do I need to just have a table
of dates and an ID number? Do I query the difference between step 1 date and
step 2 date in one query? Or can I calculate the difference between all steps
in one query. Do I need one to many, many to many? I'm just lost. Help!
Thanks so much!!!!

 

[Golfinray]

I figured out how it will work for me. May not be the best way, so I'd still
appreciate comments. Thanks!!!

 

[Evi]

Dale Fye's number table eliminated the necessary of a Date table for me. I
just append the series of dates to my table (outlined in the message in this
newsgroup with the Subject Line 'Create Date Records')
You need the Project Table with
eg ProjectID and the Project Start Date and other details only about the
project and not about the step
Then the Steps table which has StepDate and has ProjectID as a foreign key
To get the difference between step1 EndDate and step2 StartDate
get the Last date with DMax

LastDate: DMax("[EndDate]","TblSale","[YourNumberField]=" &
[YourNumberField] & " AND [EndDate]<" & Format([EndDate],"00"))

Then take it from the current date with a simple minus

SinceLast:[StartDate]- DMax("[EndDate]","TblSale","[YourNumberField]=" &
[YourNumberField] & " AND [EndDate]<" & Format([EndDate],"00"))

I chicken out of the date format issue this way.

Evi