I have a table and I want to create a field to show whether it's the first occurrence (has the oldest date) of the id in that table.
the table looks something like this and it's the last field I need help with creating a update code for.
----id----date_of_trans------custom_id--------cust_type----- 1141 2013-08-12 11412013-08-12 new 1141 2013-08-17 11412013-08-17 recurring
So only the first(oldest) entry of an id should have cust_type 'new' the rest should be 'recurring'.
Any advice would be helpful!