I have a query and one of the fields return have non-unique records (i.e there are duplicate & triplicates, and so on), call this field 'block'.
I need to create another field in this query so that the first time a record appears in the 'block' field, this new field will return '1', and then the second time the same record appears again, it will return '2' and so on. So it is kind of like a duplicate counter.
I need to create another field in this query so that the first time a record appears in the 'block' field, this new field will return '1', and then the second time the same record appears again, it will return '2' and so on. So it is kind of like a duplicate counter.