Search results
-
N
MS Access Query to show rows where one column value changes
I have a table called test. In test I have an ID and a value and a date. The dates are ordered for each ID. I want to select rows for an ID, before and after a change of value, so the following example table. RowNum--------ID------- Value -------- Date 1------------------001...