Recent content by MrHiggy

I'm trying to note the 1st, 2nd, 3rd, etc orders placed by a customer. The first field being the customer ID. They're already listed in date order and I'm trying to calculate the average lag between orders. So my intention is then to create a field for each order (up to five fields) and...

I'm trying to figure out a way of adding a counter field to a table that increments based on the values in another field, e.g. Field A 1 1 1 2 2 8 12 12 12 The result I need should look like:- Field A Field B 1 1 1 2 1 3 2 1 2 2 8 1...