I have a table that has two columns. Name and date. I need to have the query pull all of the dates in the past year and report on them. I have completed that part.
The other part of this is, I have a counter that just counts how many dates the name has attached. I need to have the query check if any of the dates are consecutive, and if they are, they should be discarded.
Example:
Eric 01/02/08
Eric 04/07/08
Eric 04/08/08
Eric 05/10/08
Total: 3 (It should discard the consecutive dates and only count it as one)
Any thoughts on how to do this?
The other part of this is, I have a counter that just counts how many dates the name has attached. I need to have the query check if any of the dates are consecutive, and if they are, they should be discarded.
Example:
Eric 01/02/08
Eric 04/07/08
Eric 04/08/08
Eric 05/10/08
Total: 3 (It should discard the consecutive dates and only count it as one)
Any thoughts on how to do this?