Search results

i think that may have worked. I used this Select a.* From mytable a left join mytable b On a.[person id]=b.[person id] and b.[Event start date] >a.[Event start date]-4 and b.[Event start date]<a.[Event start date] Where b.[person id] is null

Hi, only way i can think it might work would be to use an If formula. Custom sort by person id and then event start date and then this formula iif(b5=b4,[d5-d4],"") Any then that show as less than 4 or less can be removed. May its better to take out to excel and then bring back into access .

it would exclude it. if there were several within 4 days of each other for same person id then it would remove all but the initial one if that makes sense

Hi, i have attached an example table. So initially data needs to be sorted by "Person id" and "Event Start Date". I have highlighted cells as they are within 4 days of each other. What i need it to do is remove the latest one and keep the oldest date for the same person id. So remove the line 5...

Hi, this is what i am being asked: Cluster together separate Request Events that occur for the same Client, within a short timespan, into one combined Request Event to avoid over-counting Request activity. A new Request Event starting within 4 days of a previous Request Event ending is...

Hi, Can anyone help with VBA code for the following please. I am wanting to Cluster together separate Request Events that occur for the same Client, within a short timespan, into one combined Request Event to avoid over-counting Request activity. As per the example below. What i need to do is...