Table Sorting / Indexing

VFP9

I want to sort a table by the 'Group' C(20) and the 'Total' N(12,2) fields .
How can I sort the table by group+total. There many duplicate groups and
within the group I want it sorted by total. The totals range from .01 to
100.00.

Thanks
Tim

Leemi
Mon Aug 07 16:53:10 CDT 2006

Hi Tim:

Look at this article on how to create the index tag:

115426 Indexing on a Character and Numeric Field Together
http://support.microsoft.com/default.aspx?scid=kb;EN-US;115426

I hope this helps.

This posting is provided "AS IS" with no warranties, and confers no rights.

Sincerely,
Microsoft FoxPro Technical Support
Lee Mitchell

*-- VFP9 HAS ARRIVED!! --*
Read about all the new features of VFP9 here:
http://msdn.microsoft.com/vfoxpro/

*--Purchase VFP 9.0 here:
http://www.microsoft.com/PRODUCTS/info/product.aspx?view=22&pcid=54787e64-52
69-4500-8bf2-3f06689f4ab3&type=ovr

Keep an eye on the product lifecycle for Visual FoxPro here:
http://support.microsoft.com/gp/lifeselectindex
- VFP5 Mainstream Support retired June 30th, 2003
- VFP6 Mainstream Support retired Sept. 30th, 2003

>VFP9

>>I want to sort a table by the 'Group' C(20) and the 'Total' N(12,2)
fields .
>How can I sort the table by group+total. There many duplicate groups and
>within the group I want it sorted by total. The totals range from .01 to
>100.00.

>Thanks
>Tim

Tim
Mon Aug 07 17:07:11 CDT 2006

Thanks Lee, that did the trick.

"Lee Mitchell" <Leemi@online.microsoft.com> wrote in message
news:xMoKmvmuGHA.5872@TK2MSFTNGXA01.phx.gbl...
> Hi Tim:
>
> Look at this article on how to create the index tag:
>
> 115426 Indexing on a Character and Numeric Field Together
> http://support.microsoft.com/default.aspx?scid=kb;EN-US;115426
>
> I hope this helps.
>
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> Sincerely,
> Microsoft FoxPro Technical Support
> Lee Mitchell
>
> *-- VFP9 HAS ARRIVED!! --*
> Read about all the new features of VFP9 here:
> http://msdn.microsoft.com/vfoxpro/
>
> *--Purchase VFP 9.0 here:
> http://www.microsoft.com/PRODUCTS/info/product.aspx?view=22&pcid=54787e64-52
> 69-4500-8bf2-3f06689f4ab3&type=ovr
>
> Keep an eye on the product lifecycle for Visual FoxPro here:
> http://support.microsoft.com/gp/lifeselectindex
> - VFP5 Mainstream Support retired June 30th, 2003
> - VFP6 Mainstream Support retired Sept. 30th, 2003
>
>>VFP9
>
>>>I want to sort a table by the 'Group' C(20) and the 'Total' N(12,2)
> fields .
>>How can I sort the table by group+total. There many duplicate groups and
>>within the group I want it sorted by total. The totals range from .01 to
>>100.00.
>
>>Thanks
>>Tim
>
>