you can do what you want just using a group by query and utilising the partition function on the time element
you need to convert say
06:59
to a number that can be used by the partition function - I would suggest the number of minutes
e,g,
?(hour(#06:59#)*60)+minute(#06:59#)
419
so
Partition((hour(#06:59#)*60)+minute(#06:59#),0,144 0,10)
(1440 is the number of minutes in a day)
so you can then group your table by IP, date and the partition function and select first PK (once you have this in your table)
use this query to link back to your table on PK to return the full record
based on one of your tables (with a PK added)
Code:
SELECT Working2_IBMCV_Step3a.*
FROM (SELECT First(Working2_IBMCV_Step3a.PK) AS FirstOfPK
FROM Working2_IBMCV_Step3a
GROUP BY Working2_IBMCV_Step3a.Field1, Working2_IBMCV_Step3a.Field10, Partition((Hour([field2])*60)+Minute([field2]),0,1440,10)) AS Fst INNER JOIN Working2_IBMCV_Step3a ON Fst.FirstOfPK = Working2_IBMCV_Step3a.PK