I have a table with 1,000's of archive records that has the following fields:
uniquekey, reference, datewritten, amount
I need to run a report that, based on the 'reference' field extracts the earliest record that was inserted for a given 'reference'. I would appreciate any help. Many thanks.
uniquekey, reference, datewritten, amount
I need to run a report that, based on the 'reference' field extracts the earliest record that was inserted for a given 'reference'. I would appreciate any help. Many thanks.