Hello there, could I please ask for some help. I have a table of records that has the Fields "AccountID", "AuthDate", "AuthTime","Amount" What I'm trying to do is calculate how many unique ids have records where the AuthDate and Auth time are within 1 minute so for example if AccountID 1111 had two records on the 14/10/2014, one at 13:01:56 and one at 13:02:13 then this would be counted, obviously if there was then another on the same day at 13:02:31 then that would also be counted. Thank you in advance
... View more