Looping and checking the previous row for a value in a loop?
Posted on 2006-06-16
I am trying to work with this recordset and cant recall how to do this. Each record has a date, but when looping over the records if the date in the currentRow is equal to the date in the previous row, then don't show a date. This should be very easy to do. I just cant recall the correct syntax for doing so.
I have a query that I am looping over and each record has a "date" so:
If you notice above, the date 04/10/06 appears twice. I only want the date to appear once if it is the same so it should be like:
There must be a way to take the currentRow's date value and then look at the previous row and if its the same, make it blank.