NMiller007
Programmer
I'm using a table which tracks changes to certain fields. These changes are marked with a date/time stamp. The fields I am looking at are addresses that have two fields, address1 and address2. I want to count a change to address1 and address2 at the same time as one address change. I also want to count a change to any single field at one time as one change. Looking at the data, there are single changes to each field and changes to both, so I can't just count one or the other. Also, the times are off by a second (at least) if the changes were made at the same time.
Any ideas how I can accomplish this? It seems like I need a way to look at the previous records to see if the times are within a certain amount of time (sometimes I miss Crystal Reports).
I was thinking of grouping by hour and even minute, but what if a change is made at 1:59 and 2:00, those would then be counted as two.
Thank you.
Any ideas how I can accomplish this? It seems like I need a way to look at the previous records to see if the times are within a certain amount of time (sometimes I miss Crystal Reports).
I was thinking of grouping by hour and even minute, but what if a change is made at 1:59 and 2:00, those would then be counted as two.
Thank you.
