maybe i missed this but is there a setting that would assist to not have repeated patrol, once you export a query? am asking coz each month when doing reports i end up having to get rid of a repeated patrol so as to have an exact estimate of the number of patrol events that happened eg i could be having 000256 three times but for report sake i have to delete it to one 00256,
It looks like you are doing an Observation or Patrol Query to get this table? Using these will duplicate the patrol ID several times, either according to the number of observations, or the number of patrol legs. If you want to know the number of patrols or number of patrol observations you would be better off using a Summary Query, with Patrol ID as the group-by.
thank you rbergl definitely try that out…