> > 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
>
>



I found the issue, I was grouping on all the fields I needed to diplay


Ryan J. Lashway
http://www.lashtech.com