> What is the cleanest method to test for records that have the same ID and combind them.
>
> Ex
>
> account# Address Item1 Item2 Total
>
> 7077 Address 5.00 0.00 5.00
> 7077 Address 0.00 5.00 5.00
>
>
> and make it
>
> 7077 Address 5.00 5.00 10.00
>
>
>
>
>
> Ryan J. Lashway
> http://www.lashtech.com

There is no standard way. That should come as no suprise in an industry with either no standards or too dang many. ;)

Is there a datetime on one of the records to indicate which is the fresher record?

Mike Yearwood
Microsoft MVP Visual FoxPro 2008