Search results

  1. N

    MS Access Query to show rows where one column value changes

    I had planned on posting the link to the correct response once I had one that worked on the still working forum, but ok....
  2. N

    MS Access Query to show rows where one column value changes

    Micron, cross posted to make use of the different platforms and expertise available... this is time sensitive...
  3. N

    MS Access Query to show rows where one column value changes

    Hi, yes I want to capture all different IDs as well, but no not if the value changes for new IDs
  4. 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...
Top Bottom