D
DTTODGG
Hi!
I have a file that contains columns of:
SERIAL NUMBER, COMPANY, DATE of SALE, many other fields
In the end, I would like a report listing each company only once and showing
the oldest and newest date of sale (it would be nice to have the
corresponding serial numbers associated with the sale dat, but that's not
necessary).
131 Co_A 10/12/2005
222 Co_A 12/31/2005
123 Co_B 06/04/2006
555 Co_A 03/17/2006
324 Co_C 04/01/2006
299 Co_A 08/09/2006
484 Co_A 07/04/2006
814 Co_B 05/26/2005
Would like something like this:
Company Oldest Serial Newest Serial
Co_A 10/12/2005 131 08/09/2006 299
Co_B 05/25/2005 814 06/04/2006 123
Co_C 04/01/2006 324 04/01/2006 324
Is this possible without too much difficulty?
Thank you so much!
I have a file that contains columns of:
SERIAL NUMBER, COMPANY, DATE of SALE, many other fields
In the end, I would like a report listing each company only once and showing
the oldest and newest date of sale (it would be nice to have the
corresponding serial numbers associated with the sale dat, but that's not
necessary).
131 Co_A 10/12/2005
222 Co_A 12/31/2005
123 Co_B 06/04/2006
555 Co_A 03/17/2006
324 Co_C 04/01/2006
299 Co_A 08/09/2006
484 Co_A 07/04/2006
814 Co_B 05/26/2005
Would like something like this:
Company Oldest Serial Newest Serial
Co_A 10/12/2005 131 08/09/2006 299
Co_B 05/25/2005 814 06/04/2006 123
Co_C 04/01/2006 324 04/01/2006 324
Is this possible without too much difficulty?
Thank you so much!