I have a table where I want to calculate the difference in dates from one record to the next. To give you a little history, it's a database where we want to track project element time. In other words, a project could be "In Queue" starting at date 1/1/06. In the next record, the same project could be "Active" starting at date 1/3/06. This means that it was in the queue for 2 days.
I could put Start Date and End Date fields, but the user would have to enter the same date twice (once for End Date of the previous record, and again for the the Start Date of the next record). I'm trying to avoid this.
Is it possible?
Here's what the table looks like:
Status Start Date
In Queue 1/1/06
Active 1/3/06
Review 1/5/06
Active 1/6/06
Review 1/8/06
Complete 1/9/06
Any help will be much appreciated.
Anne
P.S. I know Access fairly well, but am not proficient at code. Be gentle!