I'm using Access 2003.
Can I compare data in a table and look for changes depending on the date?
The primary key in my table is a combination of ProjectID and AsOfDate. My AsOfDate is always the last day of the month (ex: 1/31/08, 2/28/08, 3/31/08, etc)
Ex: my table looks like:
ProjectID ...AsOfDate .....BaselineProjectExitDate
112............7/31/08.........5/11/08
112 ...........8/31/08 ........5/11/08
112 ...........9/30/08 ........7/22/08
Could I have results show when the BaselineProjectExitDate changes from the current month (ex: 9/30/08) to the previous month (8/31/08).
So the results would show something like: ProjectID 112, 5/11/08, 7/22/08. The project changed their BaselineProjectExitDate last month and they shouldn't, so I want to be alerted when it happens. This data is reviewed monthly. I'm only interested in the current month compared to the previous month.
Thanks,
Can I compare data in a table and look for changes depending on the date?
The primary key in my table is a combination of ProjectID and AsOfDate. My AsOfDate is always the last day of the month (ex: 1/31/08, 2/28/08, 3/31/08, etc)
Ex: my table looks like:
ProjectID ...AsOfDate .....BaselineProjectExitDate
112............7/31/08.........5/11/08
112 ...........8/31/08 ........5/11/08
112 ...........9/30/08 ........7/22/08
Could I have results show when the BaselineProjectExitDate changes from the current month (ex: 9/30/08) to the previous month (8/31/08).
So the results would show something like: ProjectID 112, 5/11/08, 7/22/08. The project changed their BaselineProjectExitDate last month and they shouldn't, so I want to be alerted when it happens. This data is reviewed monthly. I'm only interested in the current month compared to the previous month.
Thanks,