Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Anders Altberg
  Where is Anders Altberg?
 Uppsala
 Sweden
 Anders Altberg
 To: Scott Warris
  Where is Scott Warris?
 Lima
 Ohio - United States
 Scott Warris
 Tags
Subject: RE: Total Like Items in a table
Thread ID: 289167 Message ID: 289223 # Views: 34 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Databases, Tables and SQL Server
Date: Wednesday, December 29, 2010 5:04:13 PM         
   


> >
> > Do you mean the accumulated total of qty values for each itemnum in itemnum order?
> >
> >
itemnum qty qtytotal
> > 1 10 10
> > 2 5 15

> > and so on
> >
> > -Anders
>
> I need to group the like item numbers and then total the Qty field and store it to the qtytotal, then do an index with the unique command or something to show each item only once with the total.. I hope that helps clear this up..
>
>
itemnum  qty qtytotal
> > 11111 10 10
> > 22222 5 5
> > 11111 2 11

>
> Thanks again..

Please skip the narrative and post some made up rows of sample code, and what you want to the query result to be:
You can refer to Jun's sample code. Does his solution solve meet your requirements?

-Anders

ENTIRE THREAD

Total Like Items in a table Posted by Scott Warris @ 12/28/2010 9:50:51 PM
RE: Total Like Items in a table Posted by Anders Altberg @ 12/28/2010 10:05:28 PM
RE: Total Like Items in a table Posted by Scott Warris @ 12/29/2010 3:28:59 PM
RE: Total Like Items in a table Posted by Anders Altberg @ 12/29/2010 5:04:13 PM
RE: Total Like Items in a table Posted by Tariq mehmood @ 12/29/2010 6:31:00 AM
RE: Total Like Items in a table Posted by Jun Tangunan @ 12/29/2010 7:14:22 AM
RE: Total Like Items in a table Posted by Scott Warris @ 12/29/2010 5:15:48 PM