paddydive
Active Member
- Joined
- Jun 30, 2010
- Messages
- 460
Hi All,
I am new to Access and need your help... Here is how my table looks like
ProjectID Phase start Date End Date
---------------------------------------------------
Project1 Phase2 07/08/16 07/15/16
Project1 Phase1 06/20/16 06/29/16
Project1 Phase3 07/20/16 07/29/16
Project1 Phase4 08/23/16 09/19/16
I need to calculate the date difference between two phases.
For Example difference between End date of Phase 1 and start date of phase 2 for Project 1
I am new to Access and need your help... Here is how my table looks like
ProjectID Phase start Date End Date
---------------------------------------------------
Project1 Phase2 07/08/16 07/15/16
Project1 Phase1 06/20/16 06/29/16
Project1 Phase3 07/20/16 07/29/16
Project1 Phase4 08/23/16 09/19/16
I need to calculate the date difference between two phases.
For Example difference between End date of Phase 1 and start date of phase 2 for Project 1